N919AN
Service difficulty reports · 213
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 = 'N919AN' 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 = 'N919AN' 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 AALA20120823001Skin · wornFORWARD CARGO DOOR LOWER PORTION WORN. INSTALLED NEW SKIN PER ESO 60654.SDR AALA20120819009Pin · not seatedFLOOR PROXIMITY EMERGENCY LIGHT AT SEAT 23DEF INOPERATIVE. FOUND PUSHED BACK PIN IN QUICK DISCONNECT FOR SEAT 23DEF. RESEATED PIN. OPS CHECK NORMAL.SDR AALA20120819008Connector · brokenFLOOR PROXIMITY EMERGENCY LIGHT AT SEAT 19DEF INOPERATIVE. INSTALLED NEW CONNECTOR AT SIDEWALL JUNCTION FOR FLOOR PROXIMITY EMERGENCY LIGHT AT SEAT 19DEF. OPS CHECK NORMAL.SDR AALA20111017LGA01Light · inoperativeROW 20 SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR ROW 20 SEAT MOUNTED EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20100609TUL01Fitting · migratedUPPER NOSE WHEEL WELL FITTING MIGRATED. INSTALLED FITTING PER SRM 51-10-2 PARAGRAPH 8.SDR AALA20100602TUL09Intercostal · crackedSTATION 335.5 AND LEFT BUTTLINE 45 FLOOR INTERCOSTAL IS CRACKED AT CLIPNUT HOLE. INSTALLED NEW INTERCOSTAL PER 51-10-00.SDR AALA20100602TUL08Floor Support · corrodedCORROSION ON FLOOR SUPPORT STATION 303 RIGHT BUTTLINE 10. CORROSION REMOVAL BEYOND LIMITS. REPLACED FLOOR SUPPORT AT STATION 303 RIGHT BUTTLINE 10 PER SRM 51-10-2.SDR AALA20100602TUL07Floor Support · corrodedCORROSION ON FLOORBOARD SUPPORT STATIONS 312 TO 328 RIGHT BUTTLINE 10. INSTALLED NEW FLOORBOARD SUPPORT BETWEEN STATIONS 312 TO 328 RIGHT BUTTLINE 10.SDR AALA20100602TUL06Intercostal · corrodedCORROSION ON FLOORBEAM INTERCOSTAL STATION 333 RIGHT BUTTLINE 24. CORROSION REMOVAL BEYOND LIMITS. INTERCOSTAL REPLACED WITH NEW PART PER SRM 51-10-2.SDR AALA20100528TUL12Longeron · corrodedCORROSION ON LONGERON 23 LEFT ANGLE AT STATION 313 LEFT. REPAIRED IAW SRM 51070-12-2R, R2 AND EA B737-53-010893 DATED 5/27/10.SDR AALA20100528TUL11Angle · corrodedCORROSION ON LONGERON 23 LEFT ANGLE AT STATION 333 LEFT. REPAIRED IAW SRM 51-70-12-2R, R2 AND EA B737-53-010893 DATED 5/27/10.SDR AALA20100528TUL10Angle · corrodedCORROSION ON LONGERON 23 LEFT ANGLE AT STATION 342 LEFT. REPAIRED IAW SRM 51-70-12-2R, R2 AND EA B737-53-010893 DATED 5/27/10.SDR AALA20100528TUL09Skin · gougedDENT WITH GOUGE IN FUSELAGE SKIN AT STATION 495 BETWEEN STRINGER 28 LEFT AND 27 LEFT. INSTALLED DOUBLER PER SRM 53-00-01-2R AND EA B737-53-010994.SDR AALA20100528TUL05Angle · corrodedCORROSION ON FLOOR ANGLE STATION 993.5 LEFT BUTTLINE 33 TO LEFT BUTTLINE 45.5. REPAIRED PER EA B737-53-010948.SDR AALA20100528TUL04Angle · corrodedCORROSION ON FLOOR ANGLE RIGHT BUTTLINE 33 TO RIGHT BUTTLINE 45.5 STATION 993.5. INSTALLED ANGLE PER SRM 51-40-02 AND EA B737-53-010948.SDR AALA20100528TUL03Pan · gougedFORWARD CARGO DOOR HANDLE PAN GOUGED. REPLACED HANDLE PAN PER ESO 60654.SDR AALA20100527TUL23Skin · damagedSEVERAL SCRATCHES AT FORWARD CARGO DOOR SKIN. REMOVED DAMAGED SKIN AND INSTALLED NEW FORWARD CARGO DOOR SKIN PER ESO60654.SDR AALA20100527TUL11Rib · crackedRIGHT WING NUMBER 4 KRUEGER FLAP RIB CRACKED AT NUMBER 2 HINGE. RIGHT WING NUMBER 4 KRUEGER FLAP FABRICATED AND INSTALLED DOUBLERS AND FILLERS FOR PERMANENT REPAIR PER SRM 57-43-02-2R 2.SDR AALA20100526TUL02Angle · corrodedCORROSION ON AFT ENTRY DOORWAY CREASE ANGLE IN SEVERAL LOCATIONS. REPLACED CHORD.SDR AALA20100527TUL19Frame · crackedFRAME CRACKED AT INBOARD FASTENER AT AIR CONDITIONING BRACKET STATION 727B RIGHT. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20100527TUL18Frame · crackedFRAME CRACKED AT INBOARD FASTENER AT AIR CONDITIONING BRACKET STATION 500A RIGHT. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20100527TUL17Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING BRACKET STATION 480 RIGHT. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20100527TUL16Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING BRACKET STATION 400 RIGHT. INSTALLED REPAIR PER ECO J1159AC.SDR AALA20100527TUL15Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING SUPPORT BRACKET STATION 400 LEFT. INSTALLED FRAME REPAIR PER ECO J1159AC.SDR AALA20100527TUL14Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING BRACKET STATION 500C RIGHT. INSTALLED FRAME REPAIR PER ECO J1159AC.SDR AALA20100527TUL13Frame · crackedFRAME CRACKED AT INBOARD FASTENER OF AIR CONDITIONING SUPPORT BRACKET STATION 500C LEFT SIDE. INSTALLED FRAME REPAIR PER ECO J1159AC.SDR AALA20100526TUL08Skin · damagedSCRATCHES FOUND IN AFT CARGO COMPARTMENT SKIN DOOR. ONE SCRATCH APPROXIMATLEY 11 INCHES LENGTH BY 1/8 INCH WIDE AND ANOTHER IS APPROXIMATELY 17 INCHES BY 1/8 INCH WIDE CROSSING THE DOOR CARGO DOOR HANDLE. REMOVED OLD SKIN REPLACED WITH NEW SKIN PER ESO 60651SDR AALA20100526TUL03Web · corrodedDOOR SEAL WEB CORRODED FROM STATIONS 787 TO 847. WEB REPLACED PER SRM 51-30-01.SDR AALA20091102TUL14Control Module · faultyLANDED ABQ ACCT CREW REPORTED LEFT WING/BODY OVERHEAT LIGHT ILLUMINATED. LOWERED ALTITUDE TO FLIGHT LEVEL 250 CAUSING INCREASED FUEL BURN. LANDED ABQ WITHOUT INCIDENT FOR FUEL. PLACARD LEFT WING/BODY OVERHEAT INDICATOR INOPERATIVE AND RE-DEPARTED. REPLACEDSDR AALA20090909MIA03Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK M1672 FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHTS BATTERY PACK M1672 AS REQUIRED PER MM. ALL TESTS OK.SDR AALA20090909MIA02Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK M1670 FAILED FUNCTIONAL TEST. REPLACED BATTERY PACK AT M1670 IAW MM. TESTED OK. OK FOR SERVICE.SDR AALA20090730TUL06Skin · gougedTUL - FUSELAGE SKIN GOUGED LEFT SIDE STATION 257 STRINGER 5L. REPAIRED FUSELAGE SKIN UNDER SRM 53-00-01 AND EAB 737-53-006975.SDR AALA20090730TUL10Stringer · crackedTUL - STRINGER 3L CRACKED AT STATION 320. REPAIRED STRINGER 3L AT STATION 320 UNDER EA B737-53-006964.SDR AALA20090730TUL08Skin · dentedTUL - SKIN GOUGED AND DENTED AT STRINGER 3L AT STATION 320. INSTALLED DOUBLER UNDER SRM 53-00-01-2R.SDR AALA2009050800903Connector · looseMIA - EMERGENCY LIGHT AT SEAT 19D DOES NOT ILLUMINATE. RESECURED CONNECTOR FOR EMERGENCY LIGHT UNDER SEAT 19D.SDR AALA2009040800737Light · brokenMIA EMERGENCY EXIT LIGHT AT SEAT 13A BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY EXIT LIGHT AT SEAT 13A.SDR AALA200801830Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK AT LT EXIT DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LT EXIT DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200801831Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK AT SEAT ROW 19 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROW 19. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200800801Socket · looseDFW - EMERGENCY LIGHT AT SEAT 19D INOPERATIVE. RECONNECTED PINS ON SOCKET FOR EMERGENCY LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072113Wire Harness · inoperativeTUL - EMERGENCY LIGHT AT SEAT 15D INOPERATIVE. REPLACED HARNESS FOR EMERGENCY LIGHT AT SEAT 15D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071174Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 24D HAS BROKEN SHROUD. REPLACED SHROUD EMERGENCY LIGHT AT SEAT 24D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071173Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 18D HAS BROKEN SHROUD. REPLACED SHROUD EMERGENCY LIGHT AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071172Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 16D HAS BROKEN SHROUD. REPLACED SHROUD EMERGENCY LIGHT AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071171Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 10D HAS BROKEN SHROUD. REPLACED SHROUD EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071170Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 8D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071169Light · inoperativeDFW - EMERGENCY SEAT MOUNTED LIGHT AT AFT SEAT 14D INOPERATIVE. REPLACED EMERGENCY SEAT MOUNTED LIGHT ASSEMBLY AT AFT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071164Lens · missingDFW - EMERGENCY LIGHT AT LEFT AFT GALLEY DOOR MISSING LENS COVER. REPLACED LENS COVER FOR EMERGENCY LIGHT AT LEFT AFT GALLEY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071163Lens · missingDFW - EMERGENCY LIGHT AT RIGHT AFT GALLEY DOOR MISSING LENS COVER. REPLACED LENS COVER FOR EMERGENCY LIGHT AT RIGHT AFT GALLEY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071168Light · brokenDFW - EMERGENCY EXIT IDENTIFIER LIGHT AT LEFT FORWARD SERVICE DOOR L1187 HAS BROKEN BASE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY L1187 FOR EMERGENCY LIGHT AT LEFT FORWARD SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071166Light · brokenDFW - EMERGENCY EXIT IDENTIFIER LIGHT AT LEFT AFT CABIN DOOR L1190 HAS BROKEN BASE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY L1190 FOR EMERGENCY LIGHT AT LEFT AFT CABIN DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N919AN