N905AN
Service difficulty reports · 270
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N905AN' AND registry_match = 'registration' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N905AN' AND registry_match = 'registration' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA200810405Frame · crackedSTATION 440 RIGHT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810404Frame · crackedSTATION 400 RIGHT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810403Intercostal · crackedFLOORBOARD STRINGER CRACKED AT CENTER MOUNT HOLE BETWEEN STATION 259 AND 295. REPAIRED PER SRM 53-10-04.SDR AALA200802729Control Module · faultedPIT INFLIGHT LAX TO IAD - DURING CRUISE, CREW REPORTED ENGINE NR 1 HYDRAULIC LOW PRESSURE INDICATION ILLUMINATED FOLLOWED BY ENGINE NUMBER TWO HYDRAULIC LOW PRESSURE INDICATION. CREW TURNED OFF BOTH PUMPS AND LANDED PIT WITHOUT INCIDENT. EICAS SHOWED NORMAL SDR AALA200801883Light · damagedMIA - EMERGENCY LIGHT AT RT NR 1 DOOR DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RT NR 1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200801884Light · damagedMIA - EMERGENCY LIGHT AT LT NR 1 DOOR DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LT NR 1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA20072514Cover · looseMIA - EMERGENCY EXIT SIGN COVER AT AFT SERVICE DOOR FELL OFF. RESECURED EMERGENCY EXIT SIGN COVER AT AFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072490Wire Harness · inoperativeDFW - EMERGENCY LIGHTS AT SEAT ROWS 22D TO 28D INOPERATIVE. REPLACED HARNESS AT SEAT ROW 26D FOR EMERGENCY LIGHTS AT SEAT ROWS 22D TO 28D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070422Bulb · burned outMIA - EMERGENCY LIGHT AT RIGHT HAND AFT OVERWING OUTSIDE INOPERATIVE. RELAMPED EMERGENCY LIGHT AT RIGHT HAND AFT OVERWING OUTSIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070421Bulb · burned outMIA - OUTSIDE EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR SLIDE INOPERATIVE. RELAMPED EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070423Battery Pack · inoperativeMIA - EMERGENCY LIGHTS FROM SEAT ROWS 15 TO 21 INOPERATIVE. REPLACED BATTERY PACK AT SEAT 20E FOR EMERGENCY LIGHTS FROM SEAT ROWS 15 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041237Battery Pack · inoperativeRNO - CABIN EMERGENCY LIGHTS AT RIGHT SIDE SEAT ROWS 12 TO 14, 21 TO 27 AND LEFT SIDE SEAT ROWS 12 TO 20 FAILED TEST. REPLACED BATTERY PACK FOR CABIN EMERGENCY LIGHTS AT RIGHT SIDE SEAT ROWS 12 TO 14 AND 21 TO 27 AND LEFT SIDE ROWS 12 TO 20. SYSTEM GROUND CHSDR AALA20040034Slide · will not testMCI RIGHT HAND FORWARD GALLEY DOOR EVACUATION CHUTE SLIDE AT FORWARD STATION 340 RIGHT FAILED OPERATIONAL TEST. DOOR WOULD NOT FULLY OPEN WITH GIRT BAR INSTALLED. FOUND GIRT BAR RETAINER SNAGGED ON SLIDE PACK FABRIC NOT ALLOWING DOOR TO OPEN. REPLACED WITHSDR AALA20021170Charger · inoperativeLAX - DURING OVERNIGHT MAINTENANCE, OVERHEAD EMERGENCY LIGHT AT SEAT 5E INOPERATIVE. REPLACED FORWRAD RIGHT BATTERY CHARGER AND BATTERY. SYSTEM GORND CHECKED NORMAL OPERATION. (M)SDR AALA20001559Wire · brokenMIA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AFT RIGHT SIDE CABIN INOPERATIVE. REPAIRED EMERGENCY EXIT LIGHT WIRE RIGHT SIDE AFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001282Light · brokenORD - DURING OVERNIGHT, MAINTENANCE LEFT FORWARD OVERWING EMERGENCY EXIT OUTSIDE LIGHT INOPERATIVE. REPLACED LIGHT SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR AALA20001291Skin · puncturedTUL - FOUND HOLE PUNCHED IN SKIN WHILE MOVING DOCK. CUT OUT DAMAGED AND INSTALLED 2024-063 DOUBLER PER SRM 53-00-01-2-1 PAGES 201-207. (M)SDR AALA19991936Engine · stalledMSP - FLT 188 - DURING FLIGHT, NR 1 ENGINE COMPRESSOR STALL AT FL370. NR 1 ENGINE ROLLED BACK BUT RECOVERED. FLIGHT ATTENDANT OBSERVED FLAMES FROM EXHAUST. LANDED MSP WITHOUT FURTHER INCIDENT. REPLACED NR 1 ENGINE. SYSTEM GROUND CHECK NORMAL OPERATION. ESDR AALA991872Coalescer Bag · odorSAN - FLT 1626 - AFTER TAKEOFF, RUBBER ODOR IN CABIN. RETURNED AND LANDED SAN WITHOUT FURTHER INCIDENT. MAINTENANCE ACCOMPLISHED OPERATIONS CHECK OF ELECTRICAL EQUIPMENT. UNABLE TO DUPLICATE RUBBER ODOR. AS A PRECUATIONARY, CHANGED COALESER BAGS. OPERATEDSDR AALA991254Temp Control · inoperativeORD - FLT 1875 - AFTER TAKEOFF ORD-SAN, ELECTRICAL SMOKE NOTED IN COCKPIT. EMERGENCY DECLARED AND AIRCRAFT LANDED ORD WITHOUT INCIDENT. ACCOMPLISHED RUN-UP OF BOTH LEFT AND RIGHT ENGINES. REPLACED LEFT TEMPERATURE CONTROLLER THAT HAD BEEN PREVIOUSLY PLACARD
Back to N905AN