N991AN
Service difficulty reports · 116
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 = 'N991AN' 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 = 'N991AN' 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 AALA201708219051Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN LAVATORY E HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201706269048Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. PLASTIC COVER ON EMERGENCY EXIT LIGHT IS MISSING AFT LAV E. INSTALLED NEW E EXIT COVER AT AFT LAV E WALL PER AMM 33-50-00. OPS CHECKS NORMAL.SDR AALA20170512007Beam · wornWEAR DAMAGE ON THE SUPPORT BEAM AT THE PNEUMATIC ACCESS DOOR LANDING. REPAIRED IAW EA 269925.SDR AALA201704109059Lens · missingEMERGENCY EXIT LENS CAP MISSING AT ROW 14. INSTALLED NEW LENS CAP ON EMERGENCY EXIT SIGN AT ROW 14 IAW IPC 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20160706006Oven · contaminatedFLIGHT ATTENDANT REPORTED SMOKE ODOR IN THE FORWARD ENTRY AREA. NOTICED SLIGHT WHITE SMOKE NEAR L1 DOOR. PERFORMED FIM TASK 21-00-00. FOUND BURNED PLASTIC ON OVEN VENT FAN. REMOVED PLASTIC. COULDN"T FIND ANY OTHER SOURCE. CHECKED ENGINE AND APU FOR EVIDENCESDR AALA20150618026Seat Track · crackedCRACK FOUND ON FWD SEAT TRACK AT RBL 45.50 & STATION 727B. ACCOMPLISHED PERMANENT REPAIR IAW EA 252003 DATED 6 18 2015.SDR AALA20150618025Seat Track · crackedCRACK FOUND ON FWD SEAT TRACK AT RBL 24.75 & FS 727B. ACCOMPLISHED PERMANENT REPAIR IAW EA 202003 DATED 6 18 2015.SDR AALA20150618024Seat Track · crackedCRACK INDICATION ON FWD SEAT TRACK AT FS 727B & LBL 45.50 INBD SIDE FWD FASTENER HOLE. ACCOMPLISHED PERMANENT REPAIR IAW EA 252003 DATED 6 18 2015.SDR AALA20150618023Seat Track · crackedCRACK INDICATION ON FWD SEAT TRACK AT FS 727B & LBL 45.50 OTBD SIDE FWD & AFT FASTENER HOLES. ACCOMPLISHED PERMANENT REPAIR IAW EA 252003 DATED 6 18 2015.SDR AALA20150618022Seat Track · crackedCRACK INDICATION ON FWD SEAT TRACK AT FS 727B & LBL 24.75 INBD SIDE AFT FASTENER HOLE. ACCOMPLISHED PERMANENT REPAIR IAW EA 252003 DATED 6 18 2015.SDR AALA20150618021Seat Track · crackedCRACK INDICATION ON FWD SEAT TRACK AT FS 727B & LBL 24.75 OTBD SIDE AFT FASTENER HOLE. ACCOMPLISHED PERMANENT REPAIR IAW EA 252003 DATED 6 18 2015.SDR AALA20150616006Floorbeam · crackedCRACKED FLOOR SUPPORT AT BS 540, BETWEEN BL 0 & RBL 24. REPLACED FLOOR SUPPORT AT BS 540, BETWEEN BL 0 & RBL 24.SDR AALA20150613001Intercostal · crackedCABIN FLOOR STRUCTURE INTERCOSTAL CRACKED AT FLOORBOARD ATTACH SCREW BETWEEN STATION 328 - 344, LBL 46. R & R INTERCOSTAL WITH NEW IAW AARD 51-00-05-01.SDR AALA20150611008Intercostal · crackedE & E COMPARTMENT INTERCOSTAL BETWEEN FS 312 & 328 FLOORBEAMS AT LBL 46 IS CRACKED AT CTR CLIP NUT HOLE. R & R INTERCOSTAL IAW AARD 51-00-05-1.SDR AALA20140905011Trim Motor · inoperativeSTAB TRIM INDICATION FAULT. EMER DECLARED FLIGHT DIVERTED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED STAB TRIM MOTOR. SYSTEM GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20110620ORD01Battery Pack · failedBATTERY PACK FAILED TEST FOR EMERGENCY LIGHTS FROM RIGHT NUMBER 1 DOOR TO FIRST CLASS SEATS AND AISLE. REPLACED EMERGENCY LIGHT BATTERY PACK M1674. OPS CHECK NORMAL.
Back to N991AN