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 AALA20131224007Battery Pack · dischargedRT NR 2 DOOR AREA EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK M33097, OPERATIONS CHECKED NORMAL.SDR AALA20131030022Lens · missingEMERGENCY LIGHT NEAR SEAT 40G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT NEAR 40G. OPERATIONS CHECKED NORMAL.SDR AALA20131017030Light · missingEMERGENCY LIGHT NEAR SEAT 40G MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT NEAR 40G. OPERATIONS CHECKED NORMAL.SDR AALA20130618016Lens · missingESCAPE PATH LIGHT AT SEAT 23G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 23G. OPS CHECK NORMAL.SDR AALA20130618015Lens · missingESCAPE PATH LIGHT AT SEAT 24G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 24G. OPS CHECK NORMAL.SDR AALA20130618014Lens · missingESCAPE PATH LIGHT AT SEAT 32G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 32G. OPS CHECK NORMAL.SDR AALA20130618013Lens · missingESCAPE PATH LIGHT AT SEAT 25G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 25G. OPS CHECK NORMAL, .SDR AALA20130618012Lens · missingESCAPE PATH LIGHT AT SEAT 26G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 26G. OPS CHECK NORMAL.SDR AALA20130614018Light · missingESCAPE PATH LIGHT AT SEAT 23G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 23G. OPS CHECK NORMAL.SDR AALA20130614017Light · missingESCAPE PATH LIGHT AT SEAT 24G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 24G. OPS CHECK NORMAL.SDR AALA20130614016Light · missingESCAPE PATH LIGHT AT SEAT 32G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 32G. OPS CHECK NORMAL.SDR AALA20130614015Light · brokenESCAPE PATH LIGHT AT SEAT 23C BROKEN. REPLACED LIGHT ASSY FOR SEAT 23C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130614014Light · missingESCAPE PATH LIGHT AT SEAT 25G MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 25G. OPS CHECK NORMAL.SDR AALA20130614013Light · missingESCAPE PATH LIGHT AT SEAT 26G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 26G. OPS CHECK NORMALSDR AALA20130610003Light · inoperativeROW 21C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSY FOR ROW 21C ESCAPE PATH LIGHT. OPS CHECK NORMALSDR AALA20130610008Lens · missingROW 38C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 38C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130610007Light · inoperativeROW 38C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSY FOR ROW 38C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130610006Light · inoperativeROW 37C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSY FOR ROW 37C ESCAPE PATH LIGHT. OPS CHECK NORMALSDR AALA20130610005Lens · missingROW 37C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT ROW 37C.SDR AALA20130610004Lens · missingROW 21C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 21C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409011Light · inoperativeESCAPE PATH LIGHT AT SEAT 32G INOPERATIVE. REPLACED LAMP FOR SEAT 32G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409010Light · inoperativeESCAPE PATH LIGHT AT SEAT 33G INOPERATIVE. REPLACED LAMP FOR SEAT 33G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409009Light · inoperativeESCAPE PATH LIGHT AT SEAT 20G INOPERATIVE. REPLACED LAMP FOR SEAT 20G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409008Light · inoperativeESCAPE PATH LIGHT AT SEAT 31G INOPERATIVE. REPLACED LAMP FOR SEAT 31G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409007Light · inoperativeESCAPE PATH LIGHT AT SEAT 21G INOPERATIVE. REPLACED LAMP FOR SEAT 21G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409006Light · inoperativeESCAPE PATH LIGHT AT SEAT 21G INOPERATIVE. REPLACED LAMP FOR SEAT 21G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409005Light · inoperativeESCAPE PATH LIGHT AT SEAT 43C INOPERATIVE. REPLACED LAMP FOR SEAT 43C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409004Light · missingESCAPE PATH LIGHT AT SEAT 33C MISSING ASSEMBLY. REPLACED LIGHT ASSEMBLY FOR SEAT 33C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409003Light · inoperativeESCAPE PATH LIGHT AT SEAT 37G INOPERATIVE. REPLACED LAMP FOR SEAT 37G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130409002Light · inoperativeEPW ESCAPE PATH LIGHT AT SEAT 38G INOPERATIVE. REPLACED LAMP FOR SEAT 38G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130129011Lens · missingSEAT 37G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 37G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130129010Lens · missingSEAT 45C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 45C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130129009Lens · missingSEAT 24G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 24G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130128032Light · inoperativeSEAT 32G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 32G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130128031Light · missingSEAT 37G EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 37G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130128030Light · missingSEAT 45C EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 45C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130128029Light · missingSEAT 24G EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 24G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20121123001Fan · inoperativeLHR - FLIGHT ATTENDANTS REPORTED HEARING STRANGE SOUND AND A BURNT PLASTIC SMELL ABOVE SEAT 30G. FLIGHT LANDED LHR WITHOUT INCIDENT. PLACARD AFT UPPER RECIRCULATION FAN INOPERATIVE. REPLACED RECIRCULATION FAN AT AFW ON 11/23/2012. SYSTEM GROUND CHECK NORMASDR AALA20121112009Light · inoperativeROW 24C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121112008Light · inoperativeROW 44C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 44C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121112007Light · inoperativeROW 35C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 35C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121112006Light · inoperativeROW 39G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 39G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121112005Light · inoperativeROW 22G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 22G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121107014Light · inoperativeFIRST CLASS GALLEY RIGHT FORWARD ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR FIRST CLASS GALLEY RIGHT FORWARD ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121107013Light · inoperativeROW 20C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 20C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121107012Light · inoperativeROW 41C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 41C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121107011Light · inoperativeROW 32C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 32C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121107010Light · inoperativeROW 26G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMPS FOR ROW 26G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121107009Light · inoperativeROW 32G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 32G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121107008Light · deflatedROW 11G AFT ESCAPE PATH LIGHT VERY DIM. REPLACED LIGHT ASSEMBLY FOR 11G AFT ESCAPE PATH LIGHT. OPS CHECK NORMAL.
Back to N783AN