N967AN
Service difficulty reports · 253
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 = 'N967AN' 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 = 'N967AN' 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 AALA20130424012Transition Panel · corrodedIN AFT CARGO THE LEFT TRANSITION PANEL IS CORRODED FROM STATIONS 787 TO 807. REPLACED THE TRANSITION PANEL PER SRM 53-00-53 2R-5.SDR AALA20130423016Transition Panel · corrodedRIGHT TRANSITION PANEL UPPER SIDE CORRODED FROM STATIONS 747 TO 767. INSTALLED NEW ZEE CHANNEL SECTION AND SPLICE REPAIR PER SRM 53-00-53-2R-6.SDR AALA20130423015Transition Panel · corrodedRIGHT TRANSITION PANEL UPPER SIDE CORRODED FROM STATIONS 727J TO 747. INSTALLED NEW ZEE CHANNEL SECTION AND SPLICE REPAIR PER SRM 53-00-53-2R-6SDR AALA20130422034Skin · dentedUPPER RIGHT WING NUMBER 8 SLAT HAS DENT, UPPER SURFACE OF TRAILING EDGE WEDGE. ACCOMPLISHED HOT BOND CORE REPAIR PER SRM 51-70-10 AND ESO 60285.SDR AALA20130422020Frame · crackedHFEC AND MFEC INSPECTION CRACK INDICATION AT THE INBOARD FASTENER HOLE OF THE AIR CONDITIONING FRAME RAIL ATTACH POINT AT STATION 440 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0007.SDR AALA20130422019Frame · crackedCRACK INDICATION AT STATION 440 LEFT FRAME. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0006.SDR AALA20130422018Frame · crackedHFEC AND MFEC INSPECTION SHOWS CRACK INDICATION AT THE INBOARD FASTENER HOLE OF THE AIR CONDITIONING FRAME RAIL ATTACH POINT AT STATION 500A RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0007.SDR AALA20130422017Frame · crackedFRAME HAS CRACK INDICATION AT INBOARD FASTENER FOR AIR CONDITIONING RAIL BRACKET, STATION 787 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0006.SDR AALA20130422016Frame · crackedFRAME HAS CRACK INDICATION AT INBOARD FASTENER FOR AIR CONDITIOMING RAIL BRACKET, STATION 727B LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0006.SDR AALA20130422015Frame · crackedFRAME HAS CRACK AT INBOARD FASTENER FOR AIR CONDITIONING RAIL BRACKET STATION 480 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0006.SDR AALA20130422014Frame · crackedHFEC AND MFEC INSPECTION SHOWS CRACK INDICATIONS AT THE INBOARD FASTENER HOLE OF THE AIR CONDITIONING FRAME RAIL ATTACH POINT AT STATION 480 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0007.SDR AALA20130422013Frame · crackedHFEC AND MFEC INSPECTION CRACK INDICATION AT THE INBOARD FASTENER HOLE OF THE AIR CONDITIONING FRAME RAIL ATTACH POINT AT STATION 887 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0007.SDR AALA20130422012Frame · crackedFRAME HAS CRACK INDICATION AT INBOARD FASTENER FOR AIR CONDITIONING RAIL BRACKET, STATION 380 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0006.SDR AALA20130422011Frame · crackedFRAME HAS CRACK INDICATION AT INBOARD FASTENER FOR AIR CONDITIONING RAIL BRACKET, STATION 400 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0006.SDR AALA20130419021Intercostal · corrodedCORROSION ON INTERCOSTAL AT STATION 930, LEFT BUTTLINE 28. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA20130418003Floor Support · corrodedFLOORBOARD SUPPORT CORRODED AT BODY STATIONS 318 AT APPROXIMATELY RIGHT BUTTLINE 12. INSTALLED FLOORBOARD SUPPORT PER AARD 51-00-05-1.SDR AALA20130418002Intercostal · crackedFLOORBOARD SUPPORT CRACKED BETWEEN BODY STATIONS 312 TO 328 AT APPROXIMATELY RIGHT BUTTLINE 36. INSTALLED MANUFACTURED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20130426005Plate · corrodedCORROSION ON RIGHT AFT SHIELD PLATE FROM STATIONS 847 TO 867. INSTALLED NEW SHIELD PLATE PER AARD 51-00-05-1.SDR AALA20130417010Intercostal · crackedINTERCOSTAL CRACKED AT LEFT BUTTLINE 0, BETWEEN STATIONS 277 TO 294. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20130417009Intercostal · crackedINTERCOSTAL CRACKED AT FORWARD ENTRY DOOR FLOOR BETWEEN STATIONS 328 TO 344. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20130417008Intercostal · crackedINTERCOSTAL CRACKED AT FORWARD ENTRY DOOR FLOOR BETWEEN STATIONS 312 TO 328. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20130507019Skin · damagedCROWN SKIN BETWEEN STATIONS 500C 500D DAMAGED. INSTALLED EXTERNAL DOUBLER PER SRM 53-00-00 AND EA B737-53-029649.SDR AALA20130429027Angle · corrodedCORROSION ON RIGT CREASE ANGLE FROM STATIONS 945 TO 995. INSTALLED NEW CREASE ANGLE PER SRM 51-40-02.SDR AALA20120922005Transmitter · defectiveORD - CREW REPORTED TRAILING EDGE FLAP ASYMMETRY AT 27 DEGREES WITH LEFT FLAP SLIGHTLY FURTHER DOWN THEN RIGHT FLAP ON APPROACH. FLIGHT LANDED ORD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT FLAP POSITION TRANSMITTER. SYSTEM GROUND CHECSDR AALA20120627002Connector · dirtyDEN - CREW REPORTED FLAPS DID NOT EXTEND TO POSITION 1 OR ANY FURTHER WITH FLAP HANDLE. LEADING FLAP TRANSIT LIGHT STAYED ILLUMINATED. EMERGENCY DECLARED FLIGHT LANDED DEN WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. ACCOMPLISHED BITE OF FLAP SLAT ELECSDR AALA20120531002Connector · dirtySEAT MOUNTED ESCAPE PATH LIGHT AT 22D INOPERATIVE. CLEANED AND RESEATED 22D ESCAPE PATH LIGHT CONNECTOR. OPS CHECK NORMAL.SDR AALA20120103DFW03Element · inoperative(REPEAT ITEM) CREW REPORTED ON CLIMBOUT WING/BODY OVERHEAT INDICATION. CREW PERFORMED QRH AND LIGHT EXTINGUISHED. AFTER APROXIMATELY 5 MINUTES LIGHT FLICKERED FOR NEXT 10 MINUTES. EMERGENCY DECLARED FLIGHT RETURNED LANDED WITHOUT INCIDENT. AIRCRAFT REMOVEDSDR AALA20120102DFW01Clamp · looseINFLIGHT. CREW REPORTED DURING CRUISE FLIGHT LEFT WING-BODY OVERHEAT LIGHT ILLUMINATED. ACCOMPLISHED QRH PROCEDURE AND LIGHT EXTINGUISHED. FLIGHT DIVERTED LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND PNEUMATIC DUCT CLAMP LEAKING AT FORWARSDR AALA20110930AUS01Connector · not seatedSEAT MOUNTED EMERGENCY PATH LIGHT AT SEAT 22 DEF INOPERATIVE. RESEATED EMERGENCY PATH CONNECTIONS AT SEAT 22 DEF.SDR AALA20110729LAX01Sensor · faultyLAX - CREW REPORTED LEADING EDGE SLAT ASYMMETRY AND LEADING EDGE FLAP TRANSIT LIGHT WITH STICK SHAKER. EMERGENCY DECLARED FLIGHT RETURNED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEADING EDGE FLAP EXTEND PROXIMITY SENSOR F3. SYSSDR AALA20110708TUL01Stiffener · corrodedCORROSION ON TOP EDGE OF AUXILIARY POWER UNIT INLET DUCT. REPLACED UPPER ANGLE STIFFENER OF APU INLET DUCT.SDR AALA20110607TUL01Idg · inoperativeMSY - CREW REPORTED LEFT ENGINE GENERATOR FAILED WITH AUXILIARY POWER UNIT ON MEL. EMERGENCY DECLARED FLIGHT RETURNED MSY LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED INTEGRATED DRIVE GENERATOR AND GENERATOR CONTROL UNIT. SYSTEM GROUND SDR AALA20110601TUL04Idg · overservicedIAD - INFLIGHT DCA-MIA. CREW REPORTED LEFT ENGINE GENERATOR FAILED ON CLIMBOUT WITH AUXILIARY POWER UNIT ON PLACARD. EMERGENCY DECLARED FLIGHT DIVERTED IAD LANDED WITHOUT INCIDENT. FOUND LEFT INTEGRATED DRIVE GENERATOR OVERSERVICED. SERVICED TO PROPER LEVESDR AALA20110601TUL03Shroud · defectiveROW 15 RIGHT SIDE FORWARD RED ESCAPE PATH LIGHT INOPERATIVE. REPLACED SHROUD FOR ROW 15 RIGHT FORWARD RED ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110531LGA02Lens · missingROW 15 RIGHT SIDE FORWARD RED ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 15 RIGHT SIDE FORWARD RED ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130502020Floor Support · corrodedFLOORBOARD SUPPORT AT STATION 767 CORRODED. REPLACED FLOORBOARD SUPPORT.SDR AALA20091206LAX01Window · crackedAT APPROXIMATELY 30000 FEET CAPTAINS WINDSHIELD OUTER PANEL CRACKED AND AT 35000 THE WINDOW CRACKED MORE AND STARTED ARCING. CAPTAIN STARTED DESCENT AND RETURNED TO LAX WITHOUT INCIDENT. REPLACED CAPTAINS WINDSHIELD.SDR AALA2009031000571Battery Pack · dischargedMIA - EMERGENCY LIGHT ON LEFT SIDE FROM ROW 14 ON BACK INOPERATIVE. REPLACED BATTERY PACK AT SEAT 14.SDR AALA200803168Transmitter · failedBDL - INFLIGHT, CREW REPORTED FLAP DISAGREE INDICATIONS. LANDED BDL WITHOUT INCIDENT. REPLACED RIGHT FLAP POSITION TRANSMITTER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801195Light · inoperativeLGA - EMERGENCY LIGHT AT SEAT 22B INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071439Battery Pack · inoperativeTUL - EMERGENCY LIGHT IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071438Battery Pack · inoperativeTUL - EMERGENCY LIGHT IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071437Battery Pack · inoperativeTUL - EMERGENCY LIGHT IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070537Lens · damagedMIA - EMERGENCY LIGHT AT SEAT ROW 13DEF HAS LENS DAMAGED. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 13DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070536Bulb · damagedMIA - EMERGENCY LIGHT ASSEMBLY AT SEAT ROW 13DEF DAMAGED. RELAMPED EMERGENCY LIGHT AT SEAT ROW 13DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061071Window · crackedLAS INFLIGHT T1586/17NOV LAX TO YYZ - CAPTAINS LEFT NUMBER TWO WINDOW CRACKED AT FLIGHT LEVEL 350. WINDOW HEAT WAS TURNED OFF AND CAPTAIN DECLARED AN EMERGENCY. LANDED LAS WITHOUT INCIDENT. REPLACED CAPTAINS LEFT NUMBER TWO SLIDING WINDOW. SYSTEM GROUND CHSDR AALA20060764Bulb · inoperativeMIA - EMERGENCY LIGHT AT SEAT 18D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050223Wire Harness · inoperativeLGA - EMERGENCY LIGHT AT SEATS 19DEF INOPERATIVE. REPLACED SEAT HARNESS AT 19DEF FOR EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041211Smoke · detectedORD - TAKEOFF ABORTED AT 100 TO 110 KNOTS DUE TO SMOKE IN COCKPIT AND SMOKE REPORTED IN CABIN OF MODERATE INTENSITY. AIRCRAFT TAKEN OUT OF SERVICE. RIGHT HAND ENGINE WAS BORESCOPED PREVIOUS NIGHT. SP40 WAS USED TO LOOSEN BORESCOPE PLUGS. SUSPECT INGESTION SDR AALA20040821Light · damagedDFW - EMERGENCY EXIT IDENTIFIER LIGHT ASSEMBLY AFT OF LEFT AND RIGHT AFT CABIN DOOR IS DAMAGED. REPLACED EMERGENCY EXIT IDENTIFIER LIGHT ASSEMBLY FOR AFT LEFT AND RIGHT AFT CABIN DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N967AN