N954AN
Service difficulty reports · 183
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 = 'N954AN' 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 = 'N954AN' 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 AALA20120816010Frame · crackedCRACK INDICATION AT BRACKET ATTACH STATION 727 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120814016Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500F LEFT HAS A CRACK INDICATION. INSTALLED REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120814015Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 380 RIGHT HAS A CRACK INDICATION. INSTALLED REPAIRED ANGLE PER ECO J1159AD.SDR AALA20120814014Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 400 LEFT HAS A CRACK INDICATION. INSTALLED REPAIR PER ECO J1159AD.SDR AALA20120814013Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500A LEFT HAS A CRACK INDICATION. INSTALLED REPAIR ANGLE PER ECO J1159AD CARD 0007.SDR AALA20120814012Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500 H LEFT HAS A CRACK INDICATION. INSTALLED REPAIR ANGLER PER ECO J1159AD CARD 0006.SDR AALA20120814011Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500CR SHOWS CRACK INDICATION. INSTALLED REPAIR ANGLE PER ECO J1159AD CARD 0007.SDR AALA20120814010Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500AR SHOWS CRACK INDICATION. INSTALLED REPAIR DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120814009Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 480R SHOWS CRACK INDICATION. INSTALLED REPAIR DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120814008Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 440R SHOWS CRACK INDICATION. INSTALLED REPAIR DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120814007Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 400R SHOWS CRACK INDICATION. INSTALLED REAPIR DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120809009Intercostal · crackedINTERCOSTAL BETWEEN STATIONS 312 AND 328 RIGHT BUTTLINE 28 HAS VISUAL INDICATION OF CRACKS IN AREA OF NUT PLATES. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120809007Intercostal · crackedINTERCOSTAL BETWEEN STATIONS 277 TO 294 BUTTLINE 0 HAS VISUAL INDICATION OF CRACKS IN AREA OF NUT PLATES. REMOVED AND REPLACED INTERCOSTAL PER SRM.SDR AALA20120819013Angle · corrodedCORROSION AROUND 2 FASTENERS FOR Z-ANGLE AND INBOARD LEFT AFT GALLEY MOUNT AT STATION 1016. REPLACED Z-ANGLE PER SRM 53-70-51-2R.SDR AALA20120819012Angle · corrodedCORROSION ON Z-ANGLE FROM STATIONS 1006 TO 1016. REMOVED AND REPLACED Z-ANGLE.SDR AALA20120819011Angle · corrodedCORROSION AT STATION 992.8. REPLACED Z-ANGLE PER SRM 51-00-00-05.SDR AALA20120817019Web · corrodedCORROSION ON WEB AT FORWARD CARGO DOOR AREA. REPLACED WEB PER AARD 51-00-05-1.SDR AALA20110729DFW01Sign · missingLEFT AFT OVERWING EMERGENCY LIGHT EXIT SIGN MISSING E ON EXIT. REPLACED LEFT AFT OVERWING EMERGENCY EXIT SIGN. OPS CHECK NORMAL.SDR AALA20100903TUL03Skin · damagedFUSE SKIN INTERIM REPAIR DOUBLER AT STATION 390 BETWEEN STRINGER 19 LEFT AND STRINGER 20 LEFT. REPLACED DOUBLER PER SRM 53-00-01-1R AND EAS B737-53-012828 AND B737-53-012683.SDR AALA20100902TUL04Skin · dentedDENT IN NUMBER 2 SLAT LEADING EDGE. CUT OUT DENTED SKIN AND INSTALLED A FLUSH PATCH PER SRM 57-42-01-2R.SDR AALA20100826TUL02Trunnion · corrodedTHE RIGHT MAIN GEAR FORWARD TRUNNION SUPPORT AT THE OUTBOARD LOWER LUG THE INBOARD FACE IS CORRODED. REPAIRED PER SRM 57-20-90-2R AND EAB737-57-012566.SDR AALA20100825TUL02Floorbeam · corrodedCORROSION AROUND FASTENER HOLE ON FLOORBEAM 947 LEFT BUTTLINE 27. ACCOMPLISHED FLOORBEAM REPAIR PER SRM 53-00-51-2R-1 AND AARD 53-00-00-7.SDR AALA20100821TUL02Intercostal · corrodedINTERCOSTAL AT BEAM 947 TO 927 LEFT BUTTLINE 52 HAS DEEP CORROSION ON FORWARD END. REPLACED INTERCOSTAL PER SRM 51-10-02-8.SDR AALA20100826TUL03Beam · corrodedCORROSION ON TOP FLANGE OF 947 BEAM RIGHT BUTTLINE 23 TO RIGHT BUTTLINE 27. REMOVED CORRODED TOP FLANGE OF BEAM. REPAIRED PER SRM 53-00-51-2R.SDR AALA20100818TUL17Intercostal · crackedINTERCOSTAL IS CRACKED AT STATIONS 328 TO 344 AT LEFT BUTTLINE 44. REMOVED AND REPLACED THE INTERCOSTAL PER SRM 51-10-02.SDR AALA20100818TUL18Intercostal · crackedINTERCOSTAL IS CRACKED AT STATIONS 312 TO 328 AT LEFT BUTTLINE 44. REMOVED AND REPLACED THE INTERCOSTAL PER SRM 51-10-02.SDR AALA20100818TUL16Intercostal · crackedINTERCOSTAL IS CRACKED AT STATIONS 328 TO 344 AT LEFT BUTTLINE 44. REMOVED AND REPLACED THE INTERCOSTAL PER SRM 51-10-02.SDR AALA20100908TUL02Bulkhead · canningOIL CANNING FOUND ON STATION 1016 AFT BULKHEAD TOP LEFT CORNER. INSTALLED REPAIR DOUBLER PER EA B737-53-012896.SDR AALA20100823TUL01Bulkhead · corrodedSTATION 1088 BULKHEAD HAS CORROSION AROUND AUXILIARY POWER UNIT INLET PLENUM. REMOVED AND INSTALLED UPPER ANGLE PER SRM 51-10-02-OG.SDR AALA20072212Light · inoperativeMIA - EMERGENCY LIGHT AT LEFT FORWARD OVERWING INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT LEFT FORWARD OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070629Battery Pack · inoperativeTUL - EMERGENCY BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY BATTERY PACK IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041199Battery Pack · inoperativeORD - EMERGENCY LIGHTS THROUGHOUT CABIN FAILED TEST. REPLACED ALL NINE BATTERY PACKS FOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20021541Battery Pack · inoperativeDURING OVERNIGHT MAINTENANCE, EMREGENCY ESCAPE PATH LIGHTING FIRST THREE ROWS OF COACH FOUND INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTING. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N954AN