N909NN
Service difficulty reports · 66
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 = 'N909NN' 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 = 'N909NN' 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 AALA201811021001Shield · corrodedFORWARD RIGHT AFT CARGO SHEILD HAS CORROSION BETWEEN BS 492 - 500A. REPLACED THE SHIELD.SDR AALA20181031003Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON FLOOR SUPPORT AT BS 950 AND LBL 50. REPLACED FLOOR SUPPORT PER 51-00-05-1.SDR AALA20181031002Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON FLOOR SUPPORT BETWEEN BS 947 AND BS 967 AT RBL 50. REPLACED FLOOR SUPPORT PER 51-00-05-1.SDR AALA201810310009Floor Support · crackedCABIN FLOOR SUPPORT CRACKED AT BS 540 AND RBL 2. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1SDR AALA201810310008Floor Support · crackedCABIN FLOOR SUPPORT CRACKED AT BS 540 AND LBL 2. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1SDR AALA201808109009Sliding Window · faultyL2 SLIDING WINDOW DIFFICULT TO OPEN. MAINTENANCE LUBRICATED THE L2 WINDOW IAW 56-10-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201807199016Bulkhead Web · crackedBULKHEAD WEB CRACKED BEHIND THE RIGHT HYDRAULIC FILTER . REPAIRED THE BULKHEAD WEB 57-10-10-9SDR AALA20171029003Unknown · malfunctionedAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. SLC-ORD FLIGHT RETURNED TO SLC ACCOUNT LANDING GEAR WOULD NOT RETRACT. OVERWEIGHT LANDING UNEVENTFUL. ACCOMPLISHED GENERAL VISUAL INSPECTION. CLEANED PROXIMITY SWITCHES. CHECKED OPERATION OF LIMIT SWITCHES. VERSDR AALA201708109032Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. FORWARD GALLEY, ISLE EXIT LIGHT MISSING. REMOVED AND REPLACED FWD GALLEY ISLE EXIT LIGHT LENS IAW AMM 33-50-00 OPS CHECK NORMAL.SDR AALA201706129056Lens · brokenLENS ON OVERHEAD EMERGENCY EXIT AT ROW 23 LEFT AND 25 RIGHT BROKEN. REMOVED AND REPLACED LENS IAW AMM 33-51-00, GOOD FOR SERVICE.SDR AALA201705229049Slide · dislodgedON OPENING THE L1 DOOR AT GATE, EMERGENCY SLIDE COVER OPENED AND EMERGENCY SLIDE FELL OUT, DID NOT INFLATE. REINSTALLED SLIDE PACK IAW AMM 25-66-01. THE AIRCRAFT WAS GROUNDED.SDR AALA201703319027Cover · missingEMERGENCY EXIT SIGN COVER AT 1R DOOR MISSING. REPLACED EMERGENCY EXIT COVER PER M/M 33-51-01 OPS CHECK OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170216016Slide · looseL1 DOOR SLIDE PACK IS LOOSE. INSTALLED THE SLIDE PACK IAW AMM 25-66-01. OPS CHECKED GOOD.SDR AALA20170111008Latch · dirtyAIRCRAFT NOT GROUNDED. R1 EMERGENCY DOOR GIRT BAR IS DIFFICULT TO UNLATCH. CLEANED GIRT BAR LATCH. OPERATIONAL CHECK GOOD.SDR AALA20150710003Controller · faultyAIR INTERRUPTED, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CRUISE THE R2 WINDOW INNER PANE CRACKED. R & R R2 WINDOW & ASSOCIATED WINDOW HEAT CONTROLLER IAW AMM 30-41-11-000-801 & 30-41-11-400-801. SEE ALSO AALA20150708012.SDR AALA20150708012Window · crackedAIR INTERRUPTED, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CRUISE THE R2 WINDOW INNER PANE CRACKED. R & R R2 WINDOW & ASSOCIATED WINDOW HEAT CONTROLLER IAW AMM 30-41-11-000-801 & 30-41-11-400-801. SEE ALSO AALA20150710003.
Back to N909NN