N969AN
Service difficulty reports · 241
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 = 'N969AN' 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 = 'N969AN' 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 AALA2019082659080Attach Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LOWER HORIZONTAL LEFT ANGLE, AFT PANEL ATTACH BRACKET CRACKED AT FR 887, LBL 15. REPLACED ATTACH BRACKET PER BOEING DRAWING 143A5240 AND AARD 51-00-05 AND SRM 51-40-02.SDR AALA2019082879059Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR "K" WEB AT BS 1006 AND RBL 45. REPLACED WEB IAW 51-00-05-1.SDR AALA201908289004Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727I, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD AARD 51-00-05-1.SDR AALA2019082879067Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER RIB AT STATION 92.70. REPAIRED RIB PER SRM 55-10-09-2R-5.SDR AALA2019082979066Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER SECOND RIB VERTICAL STIFFENER AT STATION 92.70. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA2019082989039Seat Track · wornAIRCRAFT IN BASE MAINTENANCE: WORN SEAT TRACK BETWEEN BS 514 AND BS 518 AT RBL 45. REPLACED SEAT TRACK PER EA 297065 AND SRM 53-00-52-1A.SDR AALA2019082659076Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR BOARD SUPPORT AT FR 540, RBL -2. REPLACED FLOOR BOARD SUPPORT PER BOEING DRAWING 143A5240 AND AARD 51-00-05 AND SRM 51-40-02.SDR AALA2019082659075Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR BOARD SUPPORT AT FR 540, LBL 2. REPLACED FLOOR BOARD SUPPORT PER BOEING DRAWING 143A5240 AND AARD 51-00-05 AND SRM 51-40-02.SDR AALA2019082989041Seat Track · wornAIRCRAFT IN BASE MAINTENANCE: WORN SEAT TRACK BETWEEN BS 515 AND BS 516 AT LBL 45. REPLACED SEAT TRACK PER AARD 51-00-05-1.SDR AALA2019082989048Support Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT FRAME AT BS 695 AND RBL 70. REPLACED SUPPORT FRAME PER AARD 51-00-01.SDR AALA2019082979063Support Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT FRAME AT BS 695 AND RBL 70. REPLACED SUPPORT FRAME PER 51-00-05-1.SDR AALA201908279009Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727C+16, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299004Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BS 727J+15, RBL-20, S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299003Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BS 727J+8, RBL-20, S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082989049Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD AT BS 782 AND RBL 21. REPLACED TRANSITION SHIELD PER AARD 51-00-05.SDR AALA201908289016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727I+16, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 765, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 759, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289013Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727J+18, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD AARD 51-00-05-1.SDR AALA201908289012Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 767, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289011Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 763, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289010Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 755.5, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289009Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 748.5, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727J+12, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289007Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727J+2, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727J+5, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289005Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 727I+8, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA201908289003Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL, BS 752, RBL -20, AT S-25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908289002Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD, BS 775, RBL -20, AT S-25R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1.SDR AALA201908289001Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD, BS 792, RBL -20, AT S-25R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1.SDR AALA2019082879038Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 787, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082879036Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727+4, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082879035Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 775, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082879033Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727D+4, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279040Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 802, LBL 20, AT S26L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279032Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727J+11.5, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279030Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 778, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279029Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 783, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279028Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 770, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279027Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 780, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279026Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 777, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279025Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 770, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 775, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279022Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 766, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279021Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 761, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279020Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 759, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279018Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 747, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279017Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727I+14.5, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727I+8, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279013Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727J+12, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.
Back to N969AN