N783AN
Service difficulty reports · 324
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 = 'N783AN' 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 = 'N783AN' 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 AALA20171205006Battery · dischargedAIRCRAFT NOT GROUNDED. DUIRNG CHECK OF EMERGENCY POWER ASSIST, FOUND L1 ENTRY DOOR 9-VOLT BACKUP BATTERY LOW. REPLACED BATTERY PER CARD 2907.SDR AALA20171003003Power Supply · no testEMERGENCY EXIT LIGHT AT THE L3 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY M33406 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201709189044Battery · no testEMERGENCY POWER ASSIST SYSTEM BATTERY AT THE R2 DOOR IS INOPERATIVE. REMOVED AND REPLACED EPAS BATTERY IAW AMM 52-11-20. OPS CHECKED GOOD.SDR AALA201708219067Flashlight · missingAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT THE L1 DOOR IS MISSING. INSTALLED NEW FLASHLIGHT PER AMM 25-64-01. OPERATIONAL CHECK GOOD.SDR AALA20170705003Power Supply · inoperativeR3 DOOR EMERGENCY LIGHTS POWER SUPPLY INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD FOR SERVICE.SDR AALA201704069012Sign · damagedLT AISLE SPANNING EMERGENCY EXIT SIGN HAS BROKEN TIEWRAPS. MAINTENANCE REPLACED EMERGENCY TIEWRAPS IAW AARD 33-51-02. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704059016Sign · damagedLT AISLE SPANNING EMERGENCY EXIT SIGN HAS BROKEN TIEWRAPS. LT AISLE SPANNING EMERGENCY EXIT SIGN HAS BROKEN TIEWRAPS. REPLACE EMERGENCY TIEWRAPS IAW AARD 33-51-02. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703079009Roll Pin · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN IN THE FORWARD TOURIST CLASS HAS MISSING PINS. INSTALLED PINS IAW CMM 25-29-63. OPERATIONAL CHECK GOOD.SDR AALA20160516013Bracket · brokenAIRCRAFT WAS GNDED. EMER EXIT LIGHT AT R3 DOOR IS BROKEN. REPAIRED EMER EXIT LIGHT SUPPORT BRACKET IAW AMM 33-51-00. SYS CHECKED NORMAL.SDR AALA20160412014Pin · missingAIRCRAFT WAS GNDED. EMER EXIT SIGN BRACKET AT ROW 24 RT IS MISSING INSTALLATION PINS. INSTALLED LIGHT ASSEMBLY BRACKET MISSING PINS IAW IPC 33-51-03. SYS CHECKED NORMAL.SDR AALA20151210001Lens · missingSEAT 15H SEAT MOUNT, EMER LIGHT LENS WAS MISSING. EMER LIGHT LENS INSTALLED IAW AMM 33-51-05. ACFT IN BASE MX.SDR AALA20151208004Sliding Window · out of adjustCOCKPIT LT SLIDING WINDOW STIFF TO OPERATE. COMPLIED WITH ADJUSTMENT IAW AMM 56-11-02. ACFT IN BASE MX.SDR AALA20151207006Power Supply · inoperativeLEFT DOOR 2, AFT EXIT SIGN FOUND INOPERATIVE M33099. EMERGENCY LIGHT POWER PACK M33099 REPLACED. INSTALLATION TEST CARRIED OUT & RESULTS NORMAL IAW AMM 33-51-06. ACFT IN BASE MX.SDR AALA20151204004Power Supply · inoperativeL3 DOOR FWD & AFT AISLE EXIT SIGN M33406, FOUND INOPERATIVE. R & R POWER SUPPLY IAW AMM 33-51-01.SDR AALA20151204003Battery · failedRETRO MOD, R1 DOOR EMER POWER ASSIST SYS, BATTERY SYS TEST FAILED. R & R EMER POWER ASSIST SYS BATTERY. PERFORMED OPERATIONAL TEST IAW AMM 52-11-20. SYS CHECKED NORMAL.SDR AALA20151201002Lens · looseL1 DOOR SLIDE LIGHT LENS IS LOOSE. SECURED LENS IAW AMM 33-51-04.SDR AALA20151127013Sign · brokenL4 DOOR AFT CUT OUT EXIT SIGN FOUND BROKEN. R & R L4 DOOR CUT OUT EXIT SIGN IAW AMM 33-51-01. OPERATIONAL TESTED GOOD IAW EO B1715AA CARD 0005 & 0009.SDR AALA20151203001Sliding Window · out of adjustCOCKPIT RT SLIDING WINDOW STIFF TO OPERATE. ADJUSTED SLIDING WINDOW IAW AMM 56-11-02.SDR AALA20151113012Rib · corrodedLEFT WING AILERON NR 5 HINGE RIB WEB FOUND CORROSION AT BONDING JUMPER INTERFACE AREA. LEFT WING AILERON NR 5 HINGE RIB WEB REPAIRED & BONDING JUMPER BRACKET INSTALLED IAW SRM 57-51-02 REPAIR 3.SDR AALA20150430007Battery Pack · inoperativeFOUND ALL BUSINESS CLASS EMERGENCY LIGHTS INOPERATIVE. POWER SUPPLY AT FAULT IAW FIM 33-51-00. R & R BATTERY PACK IAW AMM 33-51-06 WITH GOOD OPERATIONAL CHECK.SDR AALA20141210005Battery · dischargedMAINTENANCE MSG, 28-14003 FUEL SOV BATTERY VOLTAGE IS LOW, IN VIEW. R & R FUEL SOV BATTERY REPLACED, TEST CARRIED OUT NORMAL IAW AMM 28-22-14 & 28-22-00. SYS CHECKED NORMAL.SDR AALA20141201014Light · brokenL1 DOOR EMER LIGHT ASSEMBLY FOUND BROKEN. R & R LIGHT ASSEMBLY IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20141201013Light · brokenR1 DOOR FWD EMER LIGHT ASSEMBLY FOUND BROKEN. R & R LIGHT ASSEMBLY IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20141201012Light · brokenL1 DOOR FWD EMER LIGHT ASSEMBLY FOUND BROKEN. R & R LIGHT ASSEMBLY IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20141202003Light · inoperativeR1 DOOR SLIDE EMER LIGHT INOPERATIVE. R & R LAMP IAW AMM 33-51-04. SYS CHECKED NORMAL.SDR AALA20141202002Switch · defectiveDURING PAX ENTRY DOOR EMER POWER ASSIST SYS CIRCUITRY FUNCTIONAL CHECK, R1 DOOR AMBER SQUIB CONTINUITY TEST LIGHT WOULD NOT ILLUMINATE. R & R R1 DOOR OPEN SWITCH S52125 IAW 52-11-28-000-802. SYS CHECKED NORMAL.SDR AALA20141126003Receptacle · damagedR1 DOOR EMER SLIDE LIGHT DL33222 RECEPTACLE FOUND DAMAGED. R & R RECEPTACLE IAW AMM 33-51-04 & WDM 33-51-41. SYS CHECKED NORMAL.SDR AALA20141202004Skin · deformedR1 DOOR AFT LOWER CORNER SKIN FOUND DEFORMED. REPAIRED LOWER CORNER SKIN IAW SRM 52-10-01-2R-8 PROCEDURE REPAIR 8.SDR AALA20141119003Wedge · delaminatedLEFT OTBD FLAP TE WEDGE UPPER SURFACE DELAMINATED 5 FEET OTBD OF THE INBD EDGE. REMOVED EXISTING INTERIM REPAIR FMR 7AP57449D. PERFORMED PERMANENT REPAIR IAW SRM 51-70-0 REPAIR 1 & SRM 57-53-01-2R-3 TABLE 201.SDR AALA20140909007Wire · brokenEMERGENCY EXIT LIGHTS AT ROW SEAT 3D ARE INOPERATIVE. REPLACED BROKEN WIRE FOR ESCAPE PATH LIGHT AT SEAT 3D. OPERATIONS CHECKED NORMAL.SDR AALA20140718009Lens · missingSEAT MOUNTED EMER LIGHT AT 36G MISSING LENS. REPLACED LENS FOR SEAT MOUNTED EMER LIGHT AT 36G. OPERATIONS CHECKED NORMAL.SDR AALA20140718008Light · inoperativeSEAT MOUNTED EMER LIGHT AT 36C INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMER LIGHT AT 36C. OPERATIONS CHECKED NORMAL.SDR AALA20140718007Lens · missingSEAT MOUNTED EMER LIGHT AT 22C MISSING LENS. REPLACED LENS FOR SEAT MOUNTED EMER LIGHT AT 22C. OPERATIONS CHECKED NORMAL.SDR AALA20140718006Lens · missingSEAT MOUNTED EMER LIGHT AT 38G MISSING LENS. REPLACED LENS FOR SEAT MOUNTED EMER LIGHT AT 38G. OPERATIONS CHECKED NORMAL.SDR AALA20140717008Light · inoperativeSEAT MOUNTED EMER LIGHT AT 36G INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMER LIGHT AT 36G. OPERATIONS CHECKED NORMAL.SDR AALA20140717007Lens · missingSEAT MOUNTED EMER LIGHT AT 36C MISSING LENS. REPLACED LENS FOR SEAT MOUNTED EMER LIGHT AT 36C. OPERATIONS CHECKED NORMAL.SDR AALA20140717006Light · inoperativeSEAT MOUNTED EMER LIGHT AT 22C INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMER LIGHT AT 22C. OPERATIONS CHECKED NORMAL.SDR AALA20140717005Light · inoperativeOVERHEAD EMER PATH LIGHT LOCATED OVER RT AFT AISLE EXIT SIGN INOPERATIVE. REPLACED LAMP FOR OVERHEAD EMER PATH LIGHT LOCATED OVER RT AFT AISLE EXIT SIGN. OPERATIONS CHECKED NORMAL.SDR AALA20140717004Connector · looseSEAT MOUNTED EMER LIGHT AT SEAT 3D INOPERATIVE. SECURED LOOSE WIRE CONNECTORS FOUND ON SEAT MOUNTED EMER LIGHT ASSEMBLY AT SEAT 3D. OPERATIONS CHECKED NORMAL.SDR AALA20140717003Light · inoperativeSEAT MOUNTED EMER LIGHT AT 38G INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMER LIGHT AT 38G. OPERATIONS CHECKED NORMAL.SDR AALA20140410017Lens · missingSEAT 25G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 25G ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140410016Light · inoperativeSEAT 32G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 32G ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140410015Light · inoperativeSEAT 34G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMPS FOR SEAT 34G ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140410014Light · inoperativeSEAT 44C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMPS FOR SEAT 44C ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140410013Lens · missingSEAT 40C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 40C ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140410012Light · inoperativeSEAT 25C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 25C ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140410011Light · inoperativeSEAT 24C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 24C ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140410010Light · inoperativeSEAT 23C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 23C ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20140410009Lens · damagedFIRST CLASS GALLEY FWD LT ESCAPE PATH LIGHT LENS DAMAGED. REPLACED LENS FOR FIRST CLASS GALLEY FWD LT ESCAPE PATH LIGHT, OPERATIONS CHECKED NORMAL.SDR AALA20131224008Battery Pack · dischargedRT NR 4 DOOR AREA EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK M33408, OPERATIONS CHECKED NORMAL.
Back to N783AN