N782AN
Service difficulty reports · 219
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 = 'N782AN' 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 = 'N782AN' 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 AALA20180308005Panel · brokenSPEAKER GUARD FOR EMERGENCY PANEL BROKEN. REPLACED THE EMERGENCY PANEL AT P8 IAW AMM 25-63-02-700-801.SDR AALA20180308002Battery Pack · no testR2 DOOR EMERGENCY POWER ASSIST SYSTEM BATTERY PACK, NO GREEN LIGHT BLINKING. MAINTENANCE REPLACED R2 DOOR EMERGENCY POWER ASSIST SYSTEM BATTERY PACK PER AMM 52-11-20-000-805, 52-11-20-400-805, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 52-11-20-700SDR AALA20180308001Battery Pack · no testR3 DOOR EMERGENCY POWER ASSIST SYSTEM BATTERY PACK, NO GREEN LIGHT BLINKING. MAINTENANCE REPLACED BATTERY PACK IAW AMM 52-11-20-000-805, 52-11-400-805-002, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW 52-11-20-77-803-002.SDR AALA20180305012Power Supply · no testEMERGENCY LIGHT POWER SUPPLY M33406 FAILED TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803. OPS CHECKED GOOD.SDR AALA20180305011Power Supply · no testEMERGENCY LIGHT POWER SUPPLY M33400 FAILED TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803. OPS CHECKED GOOD.SDR AALA20180227003Connector · brokenEMERGENCY LIGHT CONNECTOR AT SEAT 13, BROKEN. MAINTENANCE REPLACED THE CONNECTOR IAW SWPM 20-61-28, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20171130017Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS BY THE R1 DOOR WILL NOT REMAIN ILLUMINATED. REMOVED AND REPLACED POWER SUPPLY M33094 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20171122004Engine · overheatedAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. NRT-DFW FLIGHT DIVERTED TO SEA ACCOUNT CREW SHUT DOWN THE NUMBER TWO ENGINE AFTER OVERHEAT/FIRE INDICATIONS (ENG FAIL R, TURB OVT SNSR ENG R, FIRE ENG R, BLEED OFF ENG R) AND HIGH VIBRATIONS. SINGLE ENGINE TIME WAS SDR AALA201710129013Megaphone · brokenMEGAPHONE AT GALLEY G7 IS BROKEN. REMOVED AND REPLACED THE MEGAPHONE IAW AMM 25-64-02. OPS CHECKED GOOD.SDR AALA201705319033Fan · failedTHE AIRCRAFT WAS GROUNDED. RECIRC FAN STATUS MESSAGE CAME ON IN FLIGHT. AT THE SAME TIME FLIGHT ATTENDANT ADVISED AN ELECTRICAL ODOR . TURNED BOTH RECIRC FANS OFF ELECTRICAL ODOR WENT AWAY. ACCOMPLISHED FIM 21-25-00. REMOVED AND REPLACED AFT UPPER RECIRCULATIOSDR AALA201703319020Roll Pin · shearedEXIT ROW SIGN OVER ROW 24C HELD IN PLACE BY TEMPORARY PLASTIC TIE. REPLACED SHEARED ROLL PINS. OK FOR SERVICE IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170215017Pin · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN RIGHT SIDE OF ROW 24 IS DETACHED. REPLACED DAMAGED ROLL PINS IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170213013Lens · missingEMERGENCY EXIT LIGHT ABOVE CENTER SEATS ROW 36 HAS A MISSING LENS . INSTALLED THE LENS IAW AMM 25-21-06. OPS CHECKED GOOD.SDR AALA20170202009Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVER SEAT 24H IS DETACHED. REPAIRED IAW AARD 33-51-01-1. OPERATIONAL CHECK GOOD.SDR AALA20170124016Pin · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R3 DOOR IS DETACHED DUE TO BROKEN PINS. REMOVED AND REPLACED PINS. OPERATIONAL CHECK GOOD.SDR AALA20170106015Roll Pin · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT ROW 24 JKL HAS A BROKEN BRACKET. REPLACED BRACKET ROLL PINS IAW ECO B2030AA. OPERATIONAL CHECK GOOD.SDR AALA20161219005Lens · missingEMERGENCY EXIT LIGHT AT ROW 27 RIGHT IS MISSING THE LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20161128009Pin · missingAIRCRAFT WAS NOT GROUNDED. ROW 24 EMERGENCY EXIT LIGHT BRACKET MISSING INSTALLATION PINS. NEW BRACKET PINS INSTALLED IAW AM 33-51-01. SYSTEM CHECKS NORMAL.SDR AALA20161123016Sign · detachedEMERGENCY EXIT SIGN AT SEATS 24ABC IS DETACHED. REPLACED BROKEN DOWEL PINS. OPERATIONAL CHECK GOOD.SDR AALA20161027003Pin · missingR3 DOOR EMERGENCY EXIT SIGN BRACKET MISSING INSTALLATION PINS. ACCOMPLISHED INTERIM REPAIR IAW ENGINEERING AUTHORIZATION 264846.SDR AALA20160509018Power Supply · inoperativeAIRCRAFT WAS IN BASE MX. R2 DOOR AFT EMER LIGHT POWER SUPPLY M33097, WAS FOUND INOPERATIVE. R & R POWER SUPPLY & ACCOMPLISHED OPERATIONAL CHECK IAW AMM 33-61-06. SYS CHECKED NORMAL.SDR AALA20160509017Power Supply · inoperativeAIRCRAFT WAS IN BASE MX. L2 DOOR AFT EMER LIGHT POWER SUPPLY M33096 WAS FOUND INOPERATIVE. R & R POWER SUPPLY & ACCOMPLISHED OPERATIONAL CHECK IAW AMM 33-61-06. SYS CHECKED NORMAL.SDR AALA20160509016Power Supply · inoperativeAIRCRAFT WAS IN BASE MX. R4 DOOR AFT EMER LIGHT POWER SUPPLY M33409 WAS FOUND INOPERATIVE. R & R POWER SUPPLY & ACCOMPLISHED OPERATIONAL CHECK IAW AMM 33-61-06. SYS CHECKED NORMAL.SDR AALA20160509002Power Supply · inoperativeAIRCRAFT WAS IN BASE MX. L2 DOOR AFT EMER POWER SUPPLY M33099, FOUND INOPERATIVE. R & R POWER SUPPLY & ACCOMPLISHED OPERATIONAL TEST IAW ECO B1715AB CARD 0004.SDR AALA20160509001Flashlight · brokenAIRCRAFT WAS IN BASE MX. L2 DOOR FWD FLIGHT ATTENDANT SEAT FLASHLIGHT STRIPE FOUND BROKEN. R & R FLASHLIGHT IAW AMM 25-64-01.SDR AALA20160504005Indicator · damagedAIRCRAFT WAS IN BASE MX. L3 DOOR FWD EMER LIGHT EXIT INDICATOR FOUND DAMAGED. R & R INDICATOR IAW AMM 33-51-01. ACCOMPLISHED OPERATIONAL TEST IAW ECO B1715AB CARD 4.SDR AALA20160425002Floor Panel · damagedAIRCRAFT WAS IN BASE MX. CABIN FLOOR PANEL BETWEEN FS 565 & 619, BETWEEN LBL 33 & 66 IS SPONGY. R & R FLOOR PANEL IAW AMM 53-01-01.SDR AALA20160420003Battery · dischargedAIRCRAFT WAS IN BASE MX. FLASHLIGHT BATTERY AT R2 DOOR SHOWS LOW POWER. R & R BATTERY IAW AMM 25-64-01.SDR AALA20160422004Spring · shearedAIRCRAFT WAS IN BASE MX. R4 DOOR FWD GIRT BAR FLOOR FITTING ATTACH SPRING FOUND SHEARED. R & R SPRING IAW ECO B1586AB CARD 0001 & AMM 52-11-18.SDR AALA20150208002Unknown · odorEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH CREW REPORTED A FLUTTERING NOISE FOLLOWED BY ELEC & SMOKE ODOR IN THE COCKPIT. SMELL DISSIPATED DURING LANDING. ACCOMPLISHED FIM 21-00-00-810-808 & INSPECTED AREA BEHIND OVERHEAD SDR AALA20141023001Switch · defectiveRIGHT NR 1 DOOR EPAS OPERATIONAL TEST FAILED DUE TO AMBER TEST LIGHT DID NOT COME ON. SWITCH REPLACED. OPERATIONS CHECKED NORMAL.SDR AALA20141017009Battery Pack · failedLEFT NR 3 DOOR BATTERY PACK FAILED CHECK. REPLACED BATTERY PACK M33400. OPERATIONS CHECKED NORMAL.SDR AALA20141017008Battery Pack · failedRIGHT NR 3 DOOR BATTERY PACK M33401 FAILED CHECK. REPLACED BATTERY PACK M33401. OPERATIONS CHECKED NORMAL.SDR AALA20141017007Battery Pack · failedRIGHT NR 3 DOOR BATTERY PACK M33404 FAILED CHECK. REPLACED BATTERY PACK M33404. OPERATIONS CHECKED NORMAL.SDR AALA20141017006Battery Pack · failedLEFT NR 1 DOOR BATTERY PACK M33424 FAILED CHECK. REPLACED BATTERY PACK M33424. OPERATIONS CHECKED NORMAL.SDR AALA20141017004Battery Pack · failedLEFT NR 3 DOOR BATTERY PACK M33405 FAILED CHECK. REPLACED BATTERY PACK M33405. OPERATIONS CHECKED NORMAL.SDR AALA20141017003Battery Pack · failedLEFT NR DOOR 1 BATTERY PACK M33093 FAILED CHECK. REPLACED BATTERY PACK M33093. OPERATIONS CHECKED NORMAL.SDR AALA20141017001Release Cable · detachedLEFT NR 4 DOOR SLIDE GIRT RELEASE CABLE FOUND DETACHED. REPLACED LT NR 4 DOOR SLIDE. OPERATIONS CHECKED NORMAL.SDR AALA20140610014Lens · missingESCAPE PATH LIGHT AT SEAT 23G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 23G. OPERATIONS CHECKED NORMAL.SDR AALA20140610013Lens · missingESCAPE PATH LIGHT AT SEAT 24G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 24G. OPERATIONS CHECKED NORMAL.SDR AALA20140610012Light · missingESCAPE PATH LIGHT AT SEAT 24G MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 24G. OPERATIONS CHECKED NORMAL.SDR AALA20140610011Lens · missingESCAPE PATH LIGHT AT SEAT 25G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 25G. OPERATIONS CHECKED NORMAL.SDR AALA20140610010Light · missingESCAPE PATH LIGHT AT SEAT 25G MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 25G. OPERATIONS CHECKED NORMAL.SDR AALA20140610009Lens · missingESCAPE PATH LIGHT AT SEAT 38G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 38G. OPERATIONS CHECKED NORMAL.SDR AALA20140610008Lens · missingESCAPE PATH LIGHT AT SEAT 37C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 37C. OPERATIONS CHECKED NORMAL.SDR AALA20140610007Light · missingESCAPE PATH LIGHT AT SEAT 37C MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 37C. OPERATIONS CHECKED NORMAL.SDR AALA20140610006Light · missingESCAPE PATH LIGHT AT SEAT 25C MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 25C. OPERATIONS CHECKED NORMAL.SDR AALA20140610005Lens · missingESCAPE PATH LIGHT AT SEAT 25C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 25C. OPERATIONS CHECKED NORMAL.SDR AALA20140610004Light · missingESCAPE PATH LIGHT AT SEAT 23C MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 23C. OPERATIONS CHECKED NORMAL.SDR AALA20140610003Lens · missingESCAPE PATH LIGHT AT SEAT 23C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 23C. OPERATIONS CHECKED NORMAL.
Back to N782AN