N946NN
Service difficulty reports · 59
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 = 'N946NN' 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 = 'N946NN' 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 AALA201907159005Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND FORWARD OVERWING ESCAPE LIGHT INOPERATIVE. MAINTENANCE REPLACED LIGHT PER AMM 33-51-04-960-801.SDR AALA2018052989013Floor Panel · damagedMAIN CABIN FLOOR PANEL HAS SOFT SPOT AT SEAT ROW 12. REPAIRED THE FLOOR PANEL IAW 53-00-00-6, REPAIR 6. AIRCRAFT WAS GROUNDEDSDR AALA201708309010Skin · corrodedAIRCRAFT WAS NOT GROUNDED. CORROSION AROUND FUSELAGE WATER DRAIN AT SECTION 43, STATION 500F, STRINGER 28L. REPAIRED PER SRM 51-10-02-0G AND SRM 53-00-01.SDR AALA201705259032Lens · missingEMERGENCY EXIT LIGHT AFT GALLEY BY THE L4 DOOR HAS A MISSING LENS. REPLACED THE LENS. OPERATIONAL CHECKED GOOD.SDR AALA201703229029Cover · missingCABIN EMERGENCY LIGHT COVER MISSING AT 2R AFT GALLEY. PART IN FLIGHT DECK. REPLACED EMERGENCY LIGHT ASSY BY 2R DOOR AND OPS CK GOOD IAW MM 33-51-00. OK FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170116014Slide · partial deployAIRCRAFT NOT GROUNDED. R1 DOOR OPENED WHILE ARMED. EMERGENCY EVACUATION SLIDE DID NOT FULLY DEPLOY. REMOVED AND REPLACED SLIDE IAW AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA20161221014Lens · missingCEILING EMERGENCY EXIT SIGN RIGHT OVERWING EXIT IS MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY IAW AMM 35-51-01. OPERATIIONAL CHECKED GOOD.SDR AALA20160426018Slide · dislodgedAIRCRAFT WAS NOT GNDED. 1R DOOR MOUNTED SLIDE PACK PARTIALLY DISLODGED FROM DOOR WHEN DOOR OPENED BY CATERING. SLIDE DID NOT DEPLOY. REPACKED SLIDE IAW AMM 25-66-01.SDR AALA20160321002Sign · brokenAIRCRAFT WAS NOT GNDED. R2 DOOR EMER EXIT ILLUMINATED SIGN IS BROKEN. R & R SIGN.
Back to N946NN