N929AN
Service difficulty reports · 254
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 = 'N929AN' 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 = 'N929AN' 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 AALA20120116TUL07Stiffener · corrodedAUXILIARY POWER UNIT INLET PLENUM AFT VERTICAL STIFFENER CORRODED. REMOVED AND REPLACED STIFFENER PER AARD 51-00-05-1.SDR AALA20120116TUL06Angle · corrodedFORWARD AUXILIARY POWER UNIT INLET PLENUM VERTICAL ANGLE CORRODED. REMOVED AND REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA20120116TUL05Frame · damagedSTATION 986.5 FRAME DAMAGED AT TIE IN TO 986.5 FLOORBEAM. ACCOMPLISHED NESTED ANGEL REPAIR PER EA B737-53-021120.SDR AALA20120116TUL04Channel · corrodedCORROSION AT SEVERAL PLACES ON LEFT Z-CHANNEL AFT ENTRY DOOR. INSTALLED NEW LEFT Z-CHANNEL (CREASE ANGLE) PER AARD 51-00-05-1.SDR AALA20120116TUL03Angle · corrodedT-ANGLE RIGHT SIDE AUXILIARY POWER UNIT COMPARMENT STATION 1116 CORRODED. REMOVED AND REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA20120116TUL02Beam · corrodedCORROSION ON STATION 947 BEAM. INSTALLED NEW T-CAP, DOUBLERS AND STIFFENERS ON FLOORBEAM 947.5 PER SRM 53-70-51-2R REPAIR 5 AND EA B737-53-021293.SDR AALA20120113TUL28Attach Angle · crackedWEB ATTACH ANGLE CRACKED BELOW FLOORBOARD TRANSITION ANGLE, LEFT STATION 500E. REMOVED AND REPLACED WEB ATTACH ANGLE PER SRM 53-00-53.SDR AALA20120113TUL27Attach Angle · crackedWEB ATTACH ANGLE CRACKED BELOW FLOORBOARD TRANSITION ANGLE LEFT STATION 500F. REMOVED AND REPLACED ANGLE PER SRM 53-00-53.SDR AALA20120113TUL26Attach Angle · crackedWEB ATTACH ANGLE CRACKED BELOW FLOORBOARD TRANSITION ANGLE, LEFT STATION 500G. REMOVED AND REPLACED ANGLE PER SRM 53-00-53.SDR AALA20120113TUL25Angle · crackedC-CLIP CRACKED BELOW TRANSITION PANEL LEFT STATION 500H. REMOVED AND REPLACED ANGLE PER SRM 53-00-53.SDR AALA20120113TUL24Angle · crackedC-CLIP ANGLE CRACKED BELOW FLOORBOARD TRANSITION ANGLE, LEFT STATION 500I. REMOVED AND REPLACED ANGLE PER SRM 53-00-53.SDR AALA20120113TUL23Attach Angle · crackedWEB ATTACH ANGLE CRACKED BELOW FLOORBOARD TRANSITION ANGLE, RIGHT STATION 500G. REMOVED AND REPLACED TRANSITION ANGLE AT RIGHT STATION 500G PER SRM 53-00-53.SDR AALA20120113TUL22Attach Angle · crackedWEB ATTACH ANGLE CRACKED BELOW FLOORBOARD TRANSITION ANGLE, RIGHT STATION 500F. REMOVED AND REPLACED WEB ATTACH ANGLE PER SRM 53-00-53.SDR AALA20120119TUL08Frame · crackedSTATION 480 LEFT AT FRAME RAIL ATTACH POINT SHOWS CRACK INDICATION. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120119TUL07Frame · crackedSTATION 440 BELOW STRINGER 8 LEFT, FRAME CRACKED AT BIN RAIL ATTACH BRACKET RIVET HOLES. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120119TUL06Frame · crackedSTATION 400 BELOW STRINGER 8 LEFT, FRAME CRACKED AT BIN RAIL ATTACH BRACKET RIVET HOLES. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120119TUL05Frame · crackedSTATION 480 BELOW STRINGER 8 RIGHT, FRAME CRACKED AT BIN RAIL ATTACH BRACKET RIVET HOLES. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120119TUL04Frame · crackedSTATION 400 BELOW STRINGER 8 RIGHT, FRAME CRACKED AT BIN RAIL ATTACH BRACKET RIVET HOLES. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120105TUL25Frame · crackedSTATION 500D RIGHT FRAME CRACKED AT BIN RAIL ATTACH BRACKET RIVET HOLES. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120110TUL01Intercostal · crackedINTERCOSTAL BETWEEN BS 312 AND 328, LBL 34 CRACKED. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA20120118TUL01Channel · corrodedCORROSION ON Z-CHANNEL AT RIGHT SERVICE DOOR FLOOR AREA. REPLACED Z-CHANNEL.SDR AALA20120120TUL03Angle · corrodedCORROSION ON CREASE ANGLE AT RIGHT NUMBER DOOR. REPLACED WITH A NEW CREASE ANGLE PER AARD 51-10-05-1.SDR AALA20120110TUL02Stiffener · crackedVERTICLE STIFFENER ON WHEEL WELL SIDE JUST OUTBOARD OF LEFT AIR CONDITIONING EXHAUST DUCT CUTOUT (APPROXIMATELY LEFT BUTTLINE 25) IS CRACKED AT LOWER END. REPLACED STIFFENER PER AARD 51-10-05 REPAIR 1.SDR AALA20110523TUL02Flap · damagedLEFT WING INBOARD TRAILING EDGE FLAP HAS DENT WITH CRACK AND TEMPORARY REPAIR IN THE SAME AREA ON THE BOTTOM SIDE. INSTALLED ONE PERMANENT BONDED DOUBLER AS PER SRM 51-70-10-2R.SDR AALA20110521TUL02Filler · corrodedCORROSION AT AUXILIARY POWER UNIT INLET DUCT LOWER SIDE OF BULKHEAD STATION 1088 (FILLER STRAP). INSTALLED LOWER FILLER AT APU INLET STATION 1088, PER AARD 51-10-05.SDR AALA20110519TUL02Skin · dentedFORWARD CARGO DOOR FIELD REPORTED 3 DENTS IN FORWARD CARGO DOOR ABOVE THE HANDLE. INSTALLED NEW SKIN PER ESO 60654.SDR AALA20110518TUL07Intercostal · crackedINTERCOSTAL IS CRACKED UNDER CABIN FLOOR AT STATION 312 TO 328 LEFT. REMOVED AND REPLACED THE INTERCOSTAL PER AARD 51-00-05.SDR AALA20110521TUL01Angle · corrodedCORROSION AT AUXILIARY POWER UNIT INLET DUCT UPPER SIDE OF BULKHEAD STATION 1088. INSTALLED NEW UPPER STIFFENER AT APU INLET STATION 1088 PER AARD 51-10-05 AND EA B737-53-017012.SDR AALA20110519TUL03Intercostal · crackedCRACKED INTERCOSTAL UNDER CABIN FLOOR AT NUTCLIP HOLES STATIONS 344 TO 360 BUTTLINE 0. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20110519TUL01Intercostal · crackedCRACK IN INTERCOSTAL UNDER CABIN FLOOR AT NUTCLIP HOLES STATIONS 344 TO 360 AT LEFT BODY LINE 11. REPLACED CRACKED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20090905DFW01Light · inoperativeLEFT AFT EXTERIOR EMERGENCY OVERWING LIGHT INOP. RELAMPED LEFT AFT OVERWING EMERGENCY LIGHT. OPS CHECK GOOD.SDR AALA20090702MIA01Pump · inoperativeMIA - INFLIGHT PAP-FLL. SYSTEM A HYDRAULIC ENGINE LOW PRESS LIGHT ILLUMINATED. EMERGENCY DECLARED, LANDED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED NUMBER ONE ENGINE HYDRAULIC PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090618TUL04Support Bracket · damagedFORWARD CARGO CABLE PULLEY SUPPORT BRACKETS ON DOOR HOLES ELONGATED. INSTALLED 2 EACH NEW PULLEY SUPPORT CASTINGS PER SRM 51-10-02G.SDR AALA20090618TUL03Intercostal · crackedINTERCOSTAL CRACKED STATION 328 TO 344 LEFT BODY LINE 48 INCHES. INSTALLED NEW INTERCOSTAL PER SRM 52-10-02G.SDR AALA2009022001032Pump · inoperativeLAS - INFLIGHT IAD-LAX - CREW REPORTED LOW PRESSURE LIGHTS FOR BOTH HYDRAULIC SYSTEMS CAME ON. EMERGENCY DECLARED, LANDED LAS WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. BOTH HYDRAULIC SYSTEM LOW PRESSURE LIGHTS ON. REPLACED RIGHT AND LEFT ENGINE DRIVSDR AALA200800552Battery Pack · dischargedMIA - EMERGENCY LIGHT AT OVERHEAD SEAT 26D INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD SEAT 26D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800549Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 24D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHTS AT SEAT 24D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800551Battery Pack · dischargedMIA - EMERGENCY LIGHT AT OVERHEAD SEAT 25C INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800550Battery Pack · dischargedMIA - EMERGENCY LIGHT AT OVERHEAD SEAT 5E INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD SEAT 5E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800553Battery Pack · dischargedMIA - EMERGENCY LIGHT AT OVERHEAD SEAT 22C INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800018Computer · failedMEX INFLIGHT T2114/02JAN - DURING CLIMB BOTH FLIGHT MANAGEMENT COMPUTERS FAILED. LANDED MEX WITHOUT INCIDENT. BOTH FLIGHT MANAGEMENT COMPUTERS WERE WORKING PRIOR TO ARRIVAL. REPLACED RIGHT AND LEFT FLIGHT MANAGEMENT COMPUTERS. SYSTEM GROUND CHECKED NORMALSDR AALA20071948Sensor · inoperativeCUN INFLIGHT T2199/16OCT - DURING CLIMB-OUT RIGHT WING TO BODY OVERHEAT INDICATION ILLUMINATED. LANDED CUN WITHOUT INCIDENT. REPLACED SENSOR M1763. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071590Connector · disconnectedLAX - EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR SLIDE INOPERATIVE. FOUND MISCONNECTION FOR DOOR EXIT IDENTIFIER. RECONNECTED WIRING FOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071436Battery Pack · inoperativeTUL - EMERGENCY LIGHT AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071435Battery Pack · inoperativeTUL - EMERGENCY LIGHT AT AFT GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT AFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070565Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 16D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070070Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 21D INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 21D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061224Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 21D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 21D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061220Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 14D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061083Connector · looseMIA - EMERGENCY LIGHT AT SEAT 14C INOPERATIVE. SECURED CONNECTOR AT SEAT 14C FOR INOPERATIVE EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N929AN