N789AN
Service difficulty reports · 262
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 = 'N789AN' 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 = 'N789AN' 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 AALA20140714006Light · missingESCAPE PATH LIGHT AT SEAT 32G MISSING LAMPS. REPLACED LAMPS FOR ESCAPE PATH LIGHT AT SEAT 32G. OPERATIONS CHECKED NORMAL.SDR AALA20140714005Lens · missingESCAPE PATH LIGHT AT SEAT 32G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 32G. OPERATIONS CHECKED NORMAL.SDR AALA20140503009Light · inoperativeESCAPE PATH LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 25C. OPERATIONS CHECKED NORMAL.SDR AALA20140503008Light · inoperativeESCAPE PATH LIGHT AT SEAT 21C INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 21C. OPERATIONS CHECKED NORMAL.SDR AALA20140503007Light · inoperativeRED ESCAPE PATH LIGHT AT SEAT 40C INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR RED ESCAPE PATH LIGHT AT SEAT 40C. OPERATIONS CHECKED NORMAL.SDR AALA20140503006Connector · looseRED ESCAPE PATH LIGHT AT SEAT 34G INOPERATIVE. SECURED LOOSE PLUG AT SEAT 34G. OPERATIONS CHECKED NORMAL.SDR AALA20140503005Connector · looseRED ESCAPE PATH LIGHT AT SEAT 30G INOPERATIVE. SECURED LOOSE PLUG AT SEAT HARNESS. OPERATIONS CHECKED NORMAL.SDR AALA20140129005Light · missingSEAT 31C EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 31C EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140111003Light · inoperativeSEAT 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 22C ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140107005Skin · damagedAPPROACHING DFW AT 11000 AIRCRAFT EXPERIENCED A STATIC DISCHARGE. STATIONS 406 TO 415, BETWEEN STRINGERS 47 & 48 LT, FUSELAGE SKIN HAS SIX EACH SMALL LIGHTNING STRIKES. BLENDED LIGHTNING STRIKES AT STATIONS 406 TO 415 BETWEEN STRINGERS 47 & 48 LT IAW 777-200SDR AALA20131203005Lens · missingFWD EMERGENCY ESCAPE PATH LIGHT AT FWD LT SIDE GALLEY MISSING LENS. REPLACED LENS FOR FWD EMERGENCY ESCAPE PATH LIGHT AT FWD LT SIDE GALLEY, OPERATIONS CHECKED NORMAL.SDR AALA20131125007Light · missingFWD EMERGENCY ESCAPE PATH LIGHT AT FWD LT SIDE GALLEY MISSING LAMP. REPLACED LAMP FOR FWD EMERGENCY ESCAPE PATH LIGHT AT FWD LT GALLEY, OPERATIONS CHECKED NORMAL.SDR AALA20130703011Lens · missingESCAPE PATH LIGHT AT SEAT 25C MISSING LENS. REPLACED LENS FOR SEAT 25C ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130703010Light · missingESCAPE PATH LIGHT AT SEAT 23G MISSING LAMP. REPLACED LAMP FOR SEAT 23G ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130703009Lens · missingESCAPE PATH LIGHT AT SEAT 23G MISSING LENS. REPLACED LENS FOR SEAT 23G ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130703008Light · inoperativeESCAPE PATH LIGHT AT SEAT 40C INOPERATIVE. REPLACED LAMP FOR SEAT 40C ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130702006Light · missingESCAPE PATH LIGHT AT SEAT 25C MISSING LAMP. REPLACED LAMP FOR SEAT 25C ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130702005Light · inoperativeESCAPE PATH LIGHT AT SEAT 31C INOPERATIVE. REPLACED LAMP FOR SEAT 31C ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130508015Light · missingESCAPE PATH LIGHT AT SEAT 41G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 41G. OPS CHECK NORMAL.SDR AALA20130508014Light · missingESCAPE PATH LIGHT AT SEAT 24G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 24G. OPS CHECK NORMAL.SDR AALA20130508013Light · missingESCAPE PATH LIGHT AT SEAT 40C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 40C. OPS CHECK NORMAL.SDR AALA20130508005Light · inoperativeESCAPE PATH LIGHT AT SEAT 41C INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 41C. OPS CHECK NORMAL.SDR AALA20130508003Light · missingESCAPE PATH LIGHT AT SEAT 35G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 35G. OPS CHECK NORMAL.SDR AALA20130508002Light · missingESCAPE PATH LIGHT AT SEAT 34C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 34C. OPS CHECK NORMAL.SDR AALA20130228004Light · missingSEAT 38G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 38G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130228003Lens · missingSEAT 42G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 42G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130227011Light · missingSEAT 42G ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 42G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130227010Light · inoperativeSEAT 45C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 45C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130227009Light · inoperativeSEAT 40C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 40C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130227008Light · inoperativeSEAT 21C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 21C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130227007Light · inoperativeSEAT 33G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 33G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130227006Light · inoperativeSEAT 22G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 22G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130227005Light · inoperativeSEAT 26G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 26G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130227004Light · missingSEAT 38G ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 38G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121213013Battery Pack · dischargedROWS 20 TO 26 SEAT MOUNTED ESCAPE PATH LIGHTS FAILED TEST. REPLACED BATTERY PACK M33404. OPS CHECK NORMAL.SDR AALA20121213012Light · inoperativeSEAT 32G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 32G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121213011Light · inoperativeSEAT 25C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 25C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121213010Light · inoperativeSEAT 26C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 26C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121213009Light · inoperativeSEAT 24C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121213008Light · inoperativeSEAT 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121213007Battery Pack · dischargedROW 20 ESCAPE PATH LIGHTS IN CEILING AND SEAT INOPERATIVE. REPLACED BATTERY PACK M33404. OPS CHECK NORMAL.SDR AALA20120726011Lens · missingESCAPE PATH LIGHT AT SEAT 26G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT 26G. OPS CHECK NORMAL.SDR AALA20120726010Light · inoperativeESCAPE PATH LIGHT AT SEAT 42G INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 42G. OPS CHECK NORMAL.SDR AALA20120705006Light · inoperativeTHE 42G SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 42G SEAT MOUNTED EMERGENCY LIGHT AT 42G. OPS CHECK NORMAL.SDR AALA20120521010Light · missingSEAT 22C ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120521009Lens · missingSEAT 21C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 21C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120519008Light · out of positionBUSINESS CLASS GALLEY ESCAPE PATH LIGHT ASSEMBLY HANGING DOWN ON AFT RIGHT SIDE OF GALLEY. RE-INSTALLED AND REPOSITIONED BUSINESS CLASS GALLEY AFT RIGHT ESCAPE PATH LIGHT ASSY, OPS CHECK NORMAL.SDR AALA20120519007Light · inoperativeLEFT NUMBER 3 DOOR AFT EXIT SIGN LAMPS INOPERATIVE. REPLACED LAMP FOR AFT EXIT SIGN AT LEFT NUMBER 3 DOOR. OPS CHECK NORMAL.SDR AALA20120519006Lens · missingSEAT 22C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120519005Light · missingSEAT 21C EPL MISSING LAMP. REPLACED LAMP FOR SEAT 21C ESCAPE PATH LIGHT, OPS CHECK NORMAL.
Back to N789AN