N965AN
Service difficulty reports · 149
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 = 'N965AN' 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 = 'N965AN' 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 AALA201805019021Battery Pack · no testEMERGENCY LIGHTS FUNCTIONAL TEST FOUND EMERGENCY LIGHTS ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED BATTERY PACK AS REQUIRED. THIS SDR IS FOR ZONE M1672 BATTERY PACK.SDR AALA201805019020Battery Pack · no testEMERGENCY LIGHTS FUNCTIONAL TEST FOUND EMERGENCY LIGHTS ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED BATTERY PACK AS REQUIRED. THIS SDR IS FOR ZONE M1695 BATTERY PACK.SDR AALA201805018003Battery Pack · no testDURING AN EMERGENCY LIGHTS FUNCTIONAL TEST, FOUND THE EMERGENCY LIGHTS AT ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED THE BATTERY PACK.SDR AALA201712289007Battery · dischargedAIRCRAFT BATTERY WILL NOT SUPPLY REQUIRED VOLTS, AMPS. REPLACED THE AIRCRAFT BATTERY PER AMM 24-11-11.SDR AALA20170502003Window Frame · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. FIRST OFFICER R1 WINDOW FRAME CORRODED ON TOP AND BOTTOM EDGES OF WINDOW SILLS A-C AND B-D. REMOVED CORROSION IAW SRM 51-10-02-0G, SRM 56-10-02-1A, AND EA 269410.SDR AALA20170430004Rib · crackedRIGHT HORIZONTAL STABILIZER MACHINED IN SPAR RIB STIFFENER CRACKED AT STABILIZER STATION 92.70 IN THE BOTTOM OF THE NR 2 AND 3 VERTICAL STIFFENERS. REPAIRED IAW SRM 55-10-09-2R -4.SDR AALA20170424001Intercostal · crackedINTERCOSTAL CRACKED IN THE ELECTRONIC EQUIPMENT BAY BETWEEN FUSELAGE BS 314 AND 328, LBL 46. REMOVED AND REPLACED INTERCOSTAL IAW 51-00-05-1 AND DRAWINGS 141A5410 AND 141A5400.SDR AALA20170502005Rib · crackedAIRCRAFT WAS IN BASE MAINTENANCE. RIGHT HORIZONTAL STABILIZER INSPAR RIB AT STABILIZER STATION 92.70 HAS DAMAGE (CRACKED/BENT) ON THE FORWARD UPPER INBOARD AND OUTBOARD FLANGES. REPAIRED IAW EA 269372, AARD 55-10-00-2, AND DRAWINGS 182A3001 AND 182A1500.SDR AALA20170106028Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN BY R2 DOOR IS DETACHED. INSTALLED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20160318001Seat Track · crackedAIRCRAFT WAS IN BASE MX. SEAT TRACK AT RBL 24 IS CRACKED, AT FUSELAGE STATION 795. ACCOMPLISHED SEAT TRACK SPLICE REPAIR IAW SRM 53-00-52-2R.SDR AALA20151104012Fuse · blownFOUND BLOWN FUSE ON CHARGER ASSEMBLY FOR M1672. R & R PACK ASSEMBLY.SDR AALA20151104011Wire · damagedESCAPE PATH LIGHTING ROW 21 - 30 INOPERATIVE. REPAIRED EMER PATH LIGHTING WIRE AT SEAT 27DEF IAW WDM 33-51-14 & AMM 33-51-06.SDR AALA20151104009Battery Pack · dischargedAISLE EMER LIGHTS AT ROW 15DEF & 17DEF INOPERATIVE. R & R BATTERY PACK ASSEMBLY AT M1671. PERFORMED OPERATIONAL CHECK IAW AMM 33-51-06. SYS CHECKED NORMAL.SDR AALA20141103001Windshield · scratchedR1 WINDSHIELD OUTER PANE SCRATCHED ALONG FULL SWEEP OF WIPER PATH. NIGHT LIGHTING IS DISTORTED & OBSCURED. R & R R1 WINDOW IAW CARD 2712. SYS CHECKED GOOD.SDR AALA20140512009Lens · missingEMERGENCY LIGHT AT SEAT 15D MISSING RED LENS. REPLACED RED LENS FOR EMER LIGHT AT SEAT 15D. OPERATIONS CHECKED NORMAL.SDR AALA20140512001Lens · missingEMERGENCY LIGHT AT SEAT 14D MISSING RED LENS. REPLACED RED LENS FOR EMER LIGHT AT SEAT 14D. OPERATIONS CHECKED NORMAL.SDR AALA20140318004Light · inoperativeFIFTH BIN MOUNTED EMERGENCY EXIT LIGHT FROM FRONT, LT SIDE IS INOPERATIVE. R & R LAMP, OPERATIONS CHECKED NORMAL.SDR AALA20130628002Wire Harness · faultyNR TWO ENGINE BLEED WOULD NOT SUPPLY PRESSURE AFTER TAKEOFF. FLIGHT LANDED SFO WITHOUT INCIDENT. REPLACED STRUT HARNESS AT THREE O CLOCK POSITION ON RT HAND ENGINE. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130408002Seat Track · crackedFORWARD SEAT TRACK AT STATION 727 AND RIGHT BUTTLINE 45.5 HAS 4 FASTENER HOLES WITH CRACK INDICATIONS. ACCOMPLISHED NESTED ANGLE REPAIR PER EA B757-53-029077.SDR AALA20130408001Seat Track · crackedFORWARD SEAT TRACK AT STATION 727 AND RIGHT BUTTLINE 24.75 HAS 4 FASTENER HOLES WITH CRACK INDICATIONS. ACCOMPLISHED NESTED ANGLE REPAIR PER EA B737-53-029077.SDR AALA20130407005Seat Track · crackedFORWARD SEAT TRACK AT STATION 727B AND LEFT BUTTLINE 45.50 HAS 3 FASTENER HOLES WITH CRACK INDICATIONS. ACCOMPLISHED NESTED ANGLE REPAIR PER EA B737-53-029077.SDR AALA20130407004Seat Track · crackedFORWARD SEAT TRACK AT STATION 727B AND LEFT BUTTLINE 24.75 HAS 4 FASTENER HOLES WITH CRACK INDICATIONS. ACCOMPLISHED NESTED ANGLE REPAIR PER EA B737-53-029077.SDR AALA20130405021Floorbeam · corrodedFLOORBEAM AT STATION 986.5 AT LEFT AND RIGHT BUTTLINES 50 CORRODED. REPLACED BEAM PER SRM 53-70-51-2R-4.SDR AALA20130402014Support · corrodedTHRESHOLD SUPPORT CORRODED AT FORWARD ENTRY DOOR. RIVETED SUPPORT ANGLE TO CREASE ANGLE PER BOEING DRAWING 141A8110.SDR AALA20130402013Angle · corrodedCREASE ANGLE AT FORWARD SERVICE DOOR IS CORRODED. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA20130321001Stiffener · corrodedRIGHT AFT AUXLIARY POWER UNIT TORQUE BOX AFT STIFFENER IS CORRODED ON INSIDE OF BOX. REMOVED AND REPLACED STIFFENER PER AARD 51-00-05-1.SDR AALA20130407001Angle · corrodedAFT WET AREA, STATION 986.5 AND LEFT BUTTLINE 43 HAS CORROSION ON CREASE ANGLE. REPLACED 986.5 BEAM PER SRM 53-70-51-2R-4 AND EA.SDR AALA20130323008Floorbeam · corrodedCORROSION ON FLOORBOARD TO FLOORBEAM FASTENERS AT STATION 328, RIGHT BUTTLINES 14 TO 30. INSTALLED STRAP PER SRM 53-10-51-2R-8.SDR AALA20120428001Valve · inoperativeSEA - CREW REPORTED RIGHT ENGINE BLEED TRIP OFF DURING CLIMBOUT. FLIGHT RETURNED SEA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SEVRICE. REPLACED HIGH STAGE VALVE, PRECOOLER VALVE SENSOR AND 450 DEGREE SENSOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20101225MIA01Windshield · crackedMIA - FIRST OFFICERS NUMBER 1 OUTER WINDOW PANE SHATTERED IN FLIGHT. RIGHT FORWARD WINDOW OVERHEAT LIGHT ALSO ILLUMINATED. EMERGENCY DECLARED FLIGHT LANDED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED WINDOW. SYSTEM GROUND CHECK NORMAL OPSDR AALA20100909MIA02Battery Pack · dischargedESCAPE PATH LIGHT BATTERY PACK FAILED TEST PER SIC WORK CARD 2908. REPLACED RIGHT AFT BATTERY PACK M1672. OPS CHECKS NORMAL.SDR AALA20100909MIA01Battery Pack · dischargedESCAPE PATH LIGHT BATTERY PACK FAILED TEST PER SIC WORK CARD 2908. REPLACED RIGHT FORWARD BATTERY PACK M1674. OPS CHECKS NORMAL.SDR AALA20100617MIA01Pump · faultyMIA - CREW REPORTED NUMBER TWO ELECTRIC HYDRAULIC PUMP OVERHEAT LIGHT ILLUMINATED DURING FLIGHT. EMERGENCY DECLARED RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER TWO ELECTRIC HYDRAULIC PUMP, CASE DRAIN AND MODULE PRESSSDR AALA20090924DFW17Plate · brokenLEFT FORWARD OVERWING HATCH FORWARD EXIT IDENTIFIER BASE PLATE IS BROKEN. REPLACED ASSEMBLY.SDR AALA20090924DFW05Plate · brokenRIGHT FORWARD OVERWING LATCH AFT EXIT IDENTIFIER BASE PLATE IS BROKEN. REPLACED ASSEMBLY.SDR AALA20090924DFW01Light · brokenRIGHT NUMBER ONE DOOR EXIT IDENTIFIER LENS BASE PLATE IS BROKEN. REPLACED ASSEMBLY.SDR AALA20090925DFW03Plate · brokenLEFT FORWARD OVERWING HATCH FORWARD EXIT IDENTIFIER BASE PLATE IS BROKEN. REPLACED LEFT FORWARD OVERWING HATCH EXIT IDENTIFIER BASE PLATE.SDR AALA20090925DFW02Plate · brokenRIGHT FORWARD OVERWING HATCH AFT EXIT IDENTIFIER BASE PLATE IS BROKEN. REPLACED RIGHT FORWARD OVERWING HATCH AFT EXIT IDENTIFIER BASE PLATE.SDR AALA20090925DFW01Plate · brokenRIGHT NUMBER 1 DOOR EXIT IDENTIFIER LENS BASE PLATE IS BROKEN. REPLACED RIGHT NUMBER 1 DOOR EXIT IDENTIFIER BASE PLATE.SDR AALA20090918MIA03Charger · failedEMERGENCY LIGHT BATTERY PACK CHARGER M1695 FAILED SIC 2908. REPLACED EMERGENCY BATTERY PACK CHARGER M1695. ACCOMPLISHED REQUIRED TEST, ALL CHECKED NORMAL.SDR AALA20090918MIA02Charger · failedEMERGENCY LIGHTS BATTERY PACK CHARGER M1674 FAILED SIC 2908. REPLACED EMERGENCY LIGHTS BATTERY PACK CHARGER M1674. ACCOMPLISHED REQUIRED TEST, ALL CHECKED NORMAL.SDR AALA20090918MIA01Charger · defectiveBATTERY PACK CHARGER M1676 FAILED SIC 2908. REPLACED EMERGENCY LIGHT BATTERY PACK CHARGER M1676. ACCOMPLISHED REQUIRED TEST, ALL CHECKED NORMAL.SDR AALA2009051500930Connector · unsecureMIA EMERGENCY LIGHTS FROM SEAT 22D TO RIGHT NUMBER 4 DOOR INOPERATIVE. SECURED CONNECTOR AT POWER SUPPLY.SDR AALA2009031000567Shroud · damagedDFW - EMERGENCY LIGHT SHROUD AT SEAT 27D DAMAGED. REPLACED EMERGENCY LIGHT SHROUD AT SEAT 27D.SDR AALA2009011800168Transmitter · failedJFK INFLIGHT DFW TO BDL - CREW REPORTED NR 2 ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED DURING DESCENT. CREW SHUT DOWN NR 2 ENGINE AND DIVERTED TO JFK. LANDED WITHOUT INCIDENT. FOUND NR 2 ENGINE PICTORIAL DEVIATION INDICATOR POPPED ON PRESSURE FILTER. REPLSDR AALA200801274Lens · brokenDFW - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR HAS BROKEN LENS. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801273Light · brokenDFW - EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR HAS BROKEN LENS. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060841Slide · inoperativeTUL - THE FORWARD GALLEY DOOR SLIDE DID NOT DEPLOY AUTOMATICALLY, IT DID DEPLOY MANUALLY. REPLACED SLIDE FOR FORWARD GALLEY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060539Lens · missingLGA - EMERGENCY LIGHT LENS AT FORWARD GALLEY MISSING. REPLACED EMERGENCY LIGHT LENS AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N965AN