N912AN
Service difficulty reports · 220
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 = 'N912AN' 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 = 'N912AN' 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 AALA20150822003Angle · corrodedCORROSION ON TOP SURFACE OF LT TRANSITION ANGLE BETWEEN STATIONS 500C & 500E. INSTALLED NEW SECTION OF TRANSITION PANEL & SPLICES STATION 500E TO 500E + 6" IAW SRM 53-00-53-2R-5.SDR AALA20150822002Angle · corrodedCORROSION ON TOP SURFACE OF LT TRANSITION ANGLE, BETWEEN STATIONS 440 & 480. INSTALLED NEW SECTION OF TRANSITION PANEL & SPLICES IAW SRM 53-00-53-2R-5.SDR AALA20150821008Window Frame · crackedL1 WINDOW FRAME CRACKED 4 INCHES DOWN FROM THE OTBD UPPER CORNER. ACCOMPLISHED PERMANENT REPAIR IAW AARD 53-10-00-6 REPAIR 6 & SB 737-53-1336.SDR AALA20150821004Skin · corrodedLEFT WING LOWER SKIN HAS VISUAL INDICATION OF CORROSION AT STATION 540. REPAIR ACCOMPLISHED IAW 253660 DATED 08 20 2015.SDR AALA20150820002Stiffener · corrodedSTIFFENER ANGLE, MPN 148A2488-24, ATTACHED TO THE FWD SIDE OF THE 1088 BULKHEAD AT THE APU INLET DUCT IS CORRODED. R & R ANGLE IAW AARD 51-00-05, SRM 51-10-02 & DWG 148A0924.SDR AALA20150818021Angle · corrodedFORWARD CARGO COMPARTMENT RT TRANSITION ANGLE IS CORRODED BETWEEN STATIONS 480 & 500A. R & R TRANSITION ANGLE IAW DWG 143A8126 SH 8 & AARD 51-10-05-1.SDR AALA20150817004Angle · crackedHORIZONTAL ANGLE CRACKED IN LT AIR CONDITIONING BAY, FWD SIDE OF VAPOR BARRIER WEB AT STATION 663.5 BETWEEN LBL 6 & LBL 32. R & R ANGLE IAW AARD 51-10-05 & DWG 111A1000.SDR AALA20150815004Intercostal · crackedCABIN FLOOR INTERCOSTAL CRACKED AT STATION 328 & RBL 43. R & R INTERCOSTAL IAW AARD 51-00-05-1.SDR AALA20150729004Power Supply · no testBOTH EMERGENCY EXIT POWER SUPPLIES, M1671 & M1672, FAILED CAPACITY CHECK IAW SIC 2908. R & R POWER SUPPLY M1672 IAW AMM 33-51-06-OPERATIONS & PERFORMED CHECK. SYSTEM CHECKED NORMAL. SEE ALSO AALA20150728001 8.SDR AALA20150728001Power Supply · no testBOTH EMERGENCY EXIT POWER SUPPLIES, M1671 & M1672, FAILED CAPACITY CHECK IAW SIC 2908. R & R POWER SUPPLY M1671 IAW AMM 33-51-06-OPERATIONS. PERFORMED CHECK, SYSTEM CHECKED NORMAL. SEE ALSO AALA20150729004.SDR AALA20150415011Aoa · faultySTALL WARNING SYS FAILED DURING CLIMB. AN EMERGENCY WAS DECLARED & FLIGHT RETURNED LANDING OVERWEIGHT WITHOUT INCIDENT. R & R LT AOA SENSOR IAW AMM 34-21-05 WITH GOOD OPERATIONAL CHECK.SDR AALA20150205002Unknown · malfunctionedAFTER TAKEOFF, LG RETRACTED & RAISED NORMALLY. WHEN THE GEAR HANDLE WAS PLACED IN OFF POSITION THE NOSE GEAR DOORS OPENED. SPEED WAS BELOW 235K. GEAR HANDLE WAS RAISED BACK UP & DOORS CLOSED. ACFT WAS FERRIED WITH GEAR DOWN. PERFORMED JACKING OF NOSE GEARSDR AALA20141223003Light · inoperativeEMERGENCY LIGHTS WILL NOT ILLUMINATE AT SEAT ROW 26DEF. R & R LAMP IAW AMM 33-51-00. SYS CHECKED NORMAL.SDR AALA20140821002Light · inoperativeOVERHEAD EMER LIGHT AT ROW 19 INOPERATIVE. REPLACED LAMP FOR OVERHEAD EMER LIGHT AT ROW 19. OPERATIONS CHECKED NORMAL.SDR AALA20140821001Connector · looseSEAT MOUNTED EMER LIGHT AT ROW 26DEF INOPERATIVE. RECONNECTED LOOSE SIDEWALL CONNECTOR AT ROW 26DEF FOR SEAT MOUNTED LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140605019Skin · cracked3.5 INCH CRACK ON LOWER RT HORIZONTAL STABILIZER. INSTALLED EXTERNAL DOUBLER USING SOLID RIVETS IAW SRM 55-10-01-2R-11.SDR AALA20130621013Seat Track · crackedCABIN AREA LT HAND SEAT TRACK AT STATION 727B & LT BUTTLINE 45.50 HAS CRACKED FASTENER HOLES ON INBOARD & OUTBOARD SIDES. ACCOMPLISHED REPAIR IAW ECO J1707AA & EA B737-53-030347.SDR AALA20130621012Seat Track · crackedCABIN AREA LT HAND SEAT TRACK AT STATION 727B & LT BUTTLINE 24.75 HAS CRACKED FASTENER HOLES ON INBOARD & OUTBOARD SIDES. INSTALLED SPLICE STRAP & ASSOCIATED FILLERS & SHIMS IAW ECO J1707AA & EA B737-53-030347.SDR AALA20130621011Seat Track · crackedINBOARD AFT HOLE IN SEAT TRACK AT RIGHT BUTTLINE 24.75 & STATION 727B HAS A CRACK INDICATION. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECOS J1698AA, J1707AB & EA B737-53-030347.SDR AALA20130621010Seat Track · crackedOUTBOARD AFT HOLE IN SET TRACK AT RIGHT BUTTLINE 24.75 & BS 727B HAS A CRACK INDICATION. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECOS J1698AA, J1707AB & EA B737-53-030347.SDR AALA20130620006Seat Track · crackedOUTBOARD FORWARD HOLE IN SEAT TRACK AT RIGHT BUTTLINE 24.75 HAS A CRACK INDICATION. INSTALLED SPLICE STRAP & ANGLE IAW ECOS J1698AA, J1707AB & EA B737-53-030347.SDR AALA20130611009Mount · corrodedMOUNT CORRODED FROM STA 972 TO 980 AND RIGHT BUTTLINES 47 TO 49. REPLACED MOUNT IAW AARD 51-00-05-1.SDR AALA20130616007Intercostal · corrodedCORROSION FOUND ON INTERCOSTAL AT STA 944 AND LT BUTTLINE 53. INSTALLED NEW INTERCOSTAL IAW AARD 51-00-05-1 AND IPC 53-42-51-23.SDR AALA20130616006Intercostal · corrodedCORROSION FOUND ON INTERCOSTAL AT STA 933 AND LT BUTTLINE 53. INSTALLED NEW INTERCOSTAL IAW AARD 51-00-05-1 AND IPC 53-42-51-23.SDR AALA20130616005Intercostal · corrodedCORROSION FOUND ON INTERCOSTAL AT STATION 931 AN LT BUTTLINE 25. INSTALLED NEW INTERCOSTAL IAW AARD 51-00-05-1 AND IPC 53-42-51-23.SDR AALA20130616004Floorbeam · corrodedCORROSION ON FLOORBEAM REPAIR FILLER AT STA 986 AND RIGHT BUTTLINES 31 TO 34. ACCOMPLISHED SPLICE REPAIR IAW SRM 53-00-51 2R, REPAIR 1 AND EA B-737-53-030174.SDR AALA20130421006Actuator · faultyMIA - CREW REPORTED LEFT LANDING GEAR WOULD NOT EXTEND. ON THIRD ATTEMPT GEAR EXTENDED. EMERGENCY DECLARED FLIGHT LANDED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED DOWNLOCK ACTUATOR ON LEFT MAIN LANDING GEAR. SYSTEM GROUND CHECK NORMAL SDR AALA20120306004Rib · damagedLIGHTNING STRIKE DAMAGE TO THE LEFT HORIZONTAL STAB OUTBOARD TIP. REPAIRED TIP CAP NUT PLATE LOWER AFT FLANGE PER SRM 55-10-90-2R1.SDR AALA20100425LAX01Detector · faultyLAX - INFLIGHT SNA-DFW - CREW REPORTED LEFT WING BODY OVERHEAT LIGHT ILLUMINATED IN FLIGHT. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. DETECTOR M1764 WAS PLACARDED AND THEN WAS REPLACED ON 05/02/2010 IN MIA. SYSTEM GROUND CHECK NORMAL SDR AALA2009082100004Connector · burnedMIA - CONNECTOR TO BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 20ABC BURNED. REPLACED CONNECTOR TO BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 20ABC.SDR AALA2009082100003Battery Pack · damagedMIA - BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 20ABC FOUND WITH BURNED PINS. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 20ABC.SDR AALA20090528TUL03Carriage · damagedNUMBER 1 FLAP CARRIAGE BELLCRANK HOLE OVERSIZED. REPAIRED PER EA COMP 57-006352 AND CARD J1071AB.SDR AALA20090528TUL02Carriage · damagedNUMBER 2 FLAP CARRIAGE HOLE OVERSIZED. REPAIRED HOLE PER EA COMP - 57-006351 AND CARD J1071AB.SDR AALA20090528TUL01Floor Support · corrodedAFT CARGO HAS CORROSION ON FLOORBOARD SUPPORT AT STATION 887. REMOVED DAMAGED AREA AND INSTALLED SERVICEABLE SUPPORT PER SRM 51-10-02.SDR AALA20090528TUL04Trans Panel · corrodedAFT CARGO HAS CORROSION ON LEFT TRANSITION PANEL STATION 815 TO 827. CUT OUT DAMAGED AREA OF Z CHANNEL AND INSTALLED REPAIR SPLICE PER SRM 53-00-53-2R.SDR AALA20090521TUL06Fitting · crackedAFT CARGO LOWER FORWARD DOOR JAMB FITTING CRACKED. INSTALLED NEW FITTING PER SRM 51-10-02.SDR AALA20090521TUL26Frame · crackedCABIN, HHEC INDICATED CRACK AT STATION 400 RIGHT FRAME RAIL SUPPORT. INSTALLED FRAME REPAIR PER ECO J1159ABSDR AALA20090521TUL02Intercostal · crackedAFT CARGO UPPER FLANGE OF INTERCOSTAL CRACKED BILGE AREA, STATION 947 RIGHT BODYLINE 21 BETWEEN 24 RIGHT AND 25 RIGHT, BELOW TRANSITION PANEL. INSTALLED NEW INTERCOSTAL PER SRM 51-10.SDR AALA20090521TUL25Angle · corrodedCABIN CHORD ANGLE CORRODED IN AFT SERVICE DOOR CUTOUT STATION 978 TO 994 RIGHT BODYLINE 50. INSTALLED STRAP REPAIR PER EA B737-53-006239.SDR AALA20090521TUL24Panel · corrodedCARGO FLOOR RIGHT HAND TRANSITION PANEL Z ANGLE HAS NUMEROUS SMALL AREAS OF CORROSION STATION 727H TO 767.SDR AALA20090521TUL23Floor Support · gougedCABIN FLOORBOARD SUPPORT GOUGED ON EDGE OF FLANGE STATION 321. REPLACED FLOORBOARD SUPPORT PER SRM 51-10-02-OG.SDR AALA20090521TUL05Web · corrodedCABIN FLOOR WEB CORRODED STATION 987 LEFT BODYLINE 45. REMOVED CORROSION AND INSTALLED DOUBLER PER SRM 51-70-13-2R.SDR AALA20090521TUL04Angle · corrodedCABIN CHORD/CREASE ANGLE INSIDE AFT ENTRY DOOR CUTOUT CORRODED AFT END, 14 INCHES. REPLACED CREASE ANGLE PER SRM 51-10-2.SDR AALA20090521TUL01Support Fitting · crackedFORWARD CARGO FOUR EACH SUPPORT CLIPS FOR Z ANGLE CRACKED STATION 500F TO 500H. INSTALLED NEW ANGLES PER SRM 51-10-02.SDR AALA20090521TUL22Web · corrodedCABIN FLOOR WEB CORRODED AT STATION 1019, RBL 33 TO 36. INSTALLED DOUBLER PER SRM 51-70-13-2R.SDR AALA20090521TUL21Support Angle · corrodedCABIN FLOOR SUPPORT ANGLE CORRODED AT STATION 1013 LEFT BODYLINE 33. REPLACED ANGLE PER EA B737-27-006268.SDR AALA20090521TUL12Angle · corrodedCABIN CHORD ANGLE CORRODED IN AFT SERVICE DOOR CUTOUT STATION 978 - 994 RIGHT BODYLINE 34. INSTALLED REPAIR STRAP PER EA B737-53-006239.SDR AALA20090520TUL16Intercostal · corrodedCABIN, CORROSION ON INTERCOSTAL STATION 962 LEFT BODYLINE 16. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02.SDR AALA20090520TUL14Intercostal · crackedCABIN FLOORBOARD INTERCOSTAL CRACKED STATION 295 TO 277 AT BODYLINE 0. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02.SDR AALA20090521TUL20Support · crackedFORWARD CARGO, ANGLE SUPPORT CRACKED AFT SIDE AT Z ANGLE LEFT HAND SIDE STATION 500H. REPLACED ANGLE SUPPORT SRM 51-10-02.
Back to N912AN