N666A, cancelled Jun 13, 2017
Service difficulty reports · 104
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 = 'N666A' AND deregistration_id = 'N666A-2017-06-13' 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 = 'N666A' AND deregistration_id = 'N666A-2017-06-13' 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 AALA20110316DFW02Light · inoperativeRIGHT NUMBER ONE DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER ONE DOOR SLIDE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20100730LGA01Pin · backed outEMERGENCY LIGHT AT SEAT 36D INOPERATIVE. RESEATED PUSHED BACK PIN AT CONNECTOR FOR EMERGENCY LIGHT AT SEAT 36D.SDR AALA20100531TUL04Skin · corrodedCORROSION ON NUMBER NINE SLAT UPPER SKIN 30 INCHES FROM INBOARD END AT REAR SPAR. INSTALLED DOUBLER.SDR AALA20100531TUL01Slat · corrodedNUMBER NINE SLAT CORRODED. ACCOMPLISHED DOUBLER REPAIR.SDR AALA20100531TUL03Floor Support · crackedFLOORBOARD SUPPORT STATION 680 TO 700 LEFT BUTTLINE 48 CRACKED. REPLACED SUPPORT PER AARD 53-30-51-2.SDR AALA20100531TUL05Floor Support · crackedFLOORBOARD SUPPORT BETWEEN STATIONS 680 TO 700 LEFT BUTTLINE 48 HAS CRACK AT AFT MOUNTING HOLE. REMOVED AND INSTALLED SUPPORT BRACKET PER AARD 53-30-51-2.SDR AALA20100531TUL02Floorbeam · crackedFLOORBEAM AT STATION 700 LEFT BUTTLINE 24 TO 48 IS CRACKED. REPAIRED FLOORBEAM AT STATION 700 LEFT BUTTLINE 24 TO LEFT BUTTLINE 48 PER PATTERN CARD 53-98--01 SRM 53-00-51-2R AND AARD 53-30-51-2.SDR AALA20100528TUL02Skin · corrodedRIGHT WING CORROSION ON NUMBER 9 SLAT UPPER SKIN 30 INCHES FROM INBOARD END. RIGHT WING NUMBER 9 SLAT REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 57-43-00-1.SDR AALA20100528TUL01Skin · corrodedRIGHT WING NUMBER 9 SLAT CORRODED ON LOWER TRAILING EDGE SKIN AT INBOARD DRIVE. RIGHT WING NUMBER 9 SLAT REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 57-43-00-1.SDR AALA20100527TUL21Skin · corrodedCORROSION ON NUMBER 8 SLAT UPPER SKIN 67 INCHES FROM OUTBOARD END. INSTALLED FLUSH DOUBLER REPAIR PER AARD 57-43-00-1.SDR AALA20100527TUL20Skin · corrodedCORROSION ON NUMBER 8 SLAT UPPER SKIN 33 INCHES FROM INBOARD END. INSTALLED REPAIR DOUBLER PER SRM 57-43-01-2 AND AARD 57-43-00-1.SDR AALA20100527TUL09Skin · corrodedRIGHT WING NUMBER 7 SLAT CORRODED AT FASTENER ON UPPER SKIN AT INBOARD DRIVE TRACK. RIGHT WING NUMBER 7 SLAT REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 57-43-00-1.SDR AALA20100527TUL08Skin · corrodedRIGHT WING NUMBER 7 SLAT CORROSION ON UPPER SKIN 27 INCHES INBOARD OF FLUSH REPAIR. RIGHT WING NUMBER 7 SLAT REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 57-43-00-1.SDR AALA20100527TUL07Skin · corrodedRIGHT WING NUMBER 8 SLAT CORROSION ON UPPER SKIN 33 INCHES FROM INBOARD END. RIGHT WING NUMBER 8 SLAT INSTALLED REPAIR DOUBLER PER SRM 57-43-01-2 AND AARD 57-43-00-1.SDR AALA20100527TUL06Skin · corrodedRIGHT WING NUMBER 8 SLAT CORROSION ON UPPER SKIN 67 INCHES FROM OUTBOARD END. RIGHT WING NUMBER 8 SLAT INSTALLED FLUSH DOUBLER REPAIR PER AARD 57-43-00-1.SDR AALA20100109JFK01Light · inoperativeBULLNOSE MOUNTED AISLE EMERGENCY LIGHT INOPERATIVE AT SEAT ROW 23AB. REPLACED LAMP.SDR AALA20091019DFW02Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 22D INOPERATIVE. RELAMPED LIGHT AT 22D.SDR AALA20091019DFW01Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 14D INOPERATIVE. RELAMPED LIGHT AT SEAT 14D.SDR AALA2009062400005Light · inoperativeDFW - LEFT AFT OVERWING DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT AFT OVERWING DOOR EMERGENCY LIGHT.SDR AALA2009062400004Battery Pack · dischargedDFW - CENTER SECTION COACH SEAT MOUNTED EMERGENCY LIGHT DIM. REPLACED BATTERY PACK FOR CENTER SECTION COACH SEAT MOUNTED EMERGENCY LIGHT.SDR AALA2009043000847Lens · missingDFW - EMERGENCY LIGHT AT SEAT 18D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 18D.SDR AALA2009043000846Light · inoperativeDFW - EMERGENCY LIGHTS AT SEAT 18 INOPERATIVE. REPLACED LAMP AT SEAT 18D FOR EMERGENCY LIGHT.SDR AALA200802522Engine · vibrationDFW INFLIGHT - AT CRUISE NR 2 ENGINE VIBRATIONS WERE ABOVE 2.0. FLUX BETWEEN 3.0 AND 1.6. CREW SHUT DOWN ENGINE. LANDED DFW WITHOUT INCIDENT. COMPRESSOR AND TURBINE BLADES CHECKED OKAY. REPLACED NR 2 ENGINE ON 14 NOV AT DFW DUE TO VIBRATIONS. SYSTEM GROUNSDR AALA200820082Panel · corrodedTRANSITION PANEL CORRODED, REPAIRED TRANSITION PANEL IAW SRM 51-10-02.SDR AALA200820078Bracket · crackedFORWARD CARGO VERTICAL CHANNEL ON FORWARD SIDE OF FLOORBEAM CRACKED. REPLACED BRACKET IAW SRM 53-00-51.SDR AALA200820077Panel · corrodedTRANSITION PANEL CORRODED. REPLACED TRANSITION PANEL IAW SRM 51-10-02.SDR AALA200820057Panel · corrodedSIDE PANEL CORRODED, REPAIRED SIDE PANEL IAW SRM 53-00-53-1A.SDR AALA200820056Galley Track · corrodedAFT GALLEY RT TIE DOWN CORRODED, REPAIRED TIE DOWN IAW SRM 53-60-51-2R.SDR AALA200820055Cargo Track · corrodedAFT GALLEY FORWARD RT TIE DOWN CORRODED, REPAIRED IAW SRM 53-60-51-2R.SDR AALA200820054Floor Support · corrodedFLOORBOARD SUPPORT CORRODED, REPAIRED IAW SRM 53-60-51-2R1.SDR AALA2008116001Floor Support · corrodedFLOORBOARD SUPPORT CORRODED. REPAIRED IAW SRM 53-60-51-2R1.SDR AALA200820053Floor Support · corrodedFLOORBOARD SUPPORT CORRODED, REPAIRED IAW SRM 53-60-51-2R1.SDR AALA200820052Plate · corrodedAFT MAIN DECK PLATE CORRODED, REPAIRED AFT DECK PLATE IAW SRM 53-60-51-2R2.SDR AALA200820051Floorbeam · corrodedFLOORBEAM CORRODED, REPAIRED IAW AARD 53-60-51-5.SDR AALA200820048Floor Support · corrodedFLOORBOARD SUPPORT HAT CHANNEL CORRODED. REPLACED FLOOR SUPPORT HAT CHANNEL IAW SRM 53-10-51-01.SDR AALA200801161Module · inoperativeDFW - EMERGENCY EXIT SIGN LIGHT AT FORWARD LAVATORY SIDEWALL INOPERATIVE. REPLACED MODULE FOR EMERGENCY EXIT SIGN LIGHT AT FORWARD LAVATORY SIDEWALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801160Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 12ABC BULLNOSE INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 12ABC BULLNOSE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801159Battery Pack · dischargedDFW - EMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT RIGHT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801158Battery Pack · dischargedDFW - EMERGENCY LIGHTS AT LEFT NUMBER TWO DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801157Battery Pack · dischargedDFW - EMERGENCY LIGHTS AT SEAT ROWS 7DEF TO 15DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 7DEF TO 15DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800937Battery Pack · inoperativeMIA - EMERGENCY LIGHTS AT SEAT ROWS 9 TO 15 INOPERATIVE. REPLACED BATTERY PACK AT RIGHT NUMBER TWO DOOR FOR EMERGENCY LIGHTS AT SEAT ROWS 9 TO 15. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072457Module · inoperativeDEN INFLIGHT T2209/16DEC DFW TO EGE, HORIZONTAL STABILIZER ASYMMETRY STATUS MESSAGE ILLUMINATED AT CRUISE. LANDED DEN WITHOUT INCIDENT. REPLACED STABILIZER TRIM AILERON CONTROL MODULE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071184Connector · looseLAX - EMERGENCY LIGHT AT SEAT 20D INOPERATIVE. SECURED LOOSE CONNECTION FOR EMERGENCY LIGHT AT SEAT 20D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071073Connector · looseMIA - EMERGENCY LIGHT AT SEAT 11D INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070967Connector · looseMIA - EMERGENCY LIGHT AT SEAT 36D INOPERATIVE. SECURED LOOSE CONNECTOR FOR EMERGENCY LIGHT AT SEAT 36D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070966Connector · looseMIA - EMERGENCY LIGHT AT SEAT 15D INOPERATIVE. SECURED LOOSE CONNECTOR FOR EMERGENCY LIGHT AT SEAT 15D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060671Light · inoperativeMIA - EMERGENCY LIGHTS AT SEATS 11D AND 15D INOPERATIVE. RELAMPED EMERGENCY LIGHTS AT SEATS 11D AND 15D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060584Light · inoperativeDFW - EMERGENCY PATH LIGHTS AT SEAT 16D INOPERATIVE. REPLACED FORWARD EMERGENCY ESCAPE PATH LIGHT ON SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060393Cable · odorINFLIGHT ELECTRICAL SMELL IN COCKPIT, SMELL & SMOKE HAZE IN CABIN. DISSIPATED AFTER TURNING OFF POWERPORTS, OVENS, OVERHEAD LIGHTS, AND WORK LIGHTS. STANDBY ALTIMETER C/B POPPED DURING FLIGHT. LANDED WITHOUT INCIDENT. SMELL REOCCURED WITH POWERPORT SWITCH SDR AALA20040934Battery Pack · inoperativeDFW - EMERGENCY LIGHTS IN THE AFT CABIN INOPERATIVE. REPLACED BATTERY PACK AND CHARGER MOD M00737 FOR EMERGENCY LIGHTS IN THE AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N666A, cancelled Jun 13, 2017