N1229A
Service difficulty reports · 362
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 = 'N1229A' 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 = 'N1229A' 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 UIEA2018021200203Seal · leakingRIGHT PACK LEAKING AT THE PRIMARY HEAT EXCHANGER UPPER CLAMP. REMOVED AND REPLACED THE SEALS, OPS CHECKED NORMAL, NO LEAKS IAW AMM 21-51-02.SDR UIEA2018021200204Line · crackedWATER EXTRACTOR BOTTOM LINE IS CRACKED IN TWO PLACES. REMOVED AND REPLACED THE WATER EXTRACTOR LINE. OPS CHECKED GOOD, NO LEAKS IAW AMM 21-51-04.SDR UIEA2018021200205Heat Exchanger · leakingLEFT HEAT EXCHANGER LEAKING AT FRONT. INSPECTED AND TIGHTENED THE CLAMPS. LEAK CHECKED GOOD IAW AMM 21-51-02.SDR UIEA2018021200206Connector · brokenLEFT ATC BAY FLOW CONTROL CONNECTOR BROKEN. REMOVED AND REPLACED THE CONNECTOR, OPS CHECKED NORMAL IAW AMM 20-62-12.SDR UIEA2018021200207Nozzle · obstructedLEFT PACK WATER SPRAY NOZZLE COMPLETELY BLOCKED. REMOVED THE BLOCKAGE, OPS CHECKED NORMAL IAW AMM 21-53-05.SDR UIEA2018021200208Controller · no testLEFT ENGINE PRESSURE CONTROLLER OPEN & CLOSE FAILED TO TEST. REMOVED AND REPLACED THE CONTROLLER ASSY IAW AMM 36-11-08, OPS CHECKED NORMAL.SDR UIEA2018013100158Warning Light · false activationLEFT OIL FILTER EICAS. PERFORMED AN ENGINE RUN IAW AMM 71-00-00. MESSAGE CLEARED, NO DEFECTS NOTED.SDR UIEA2018013000154Start Valve · defectiveRT ENGINE START EICAS MESSAGE START VALVE NOT OPENING, SECOND GATE RETURN, RT ENGINE STARTER EICAS MESSAGE, X2 START VALVE LIGHT REMAINS ILLUMINATED. MANUALLY CYCLED START VALVE, OPS CHECKED THE START VALVE IAW AMM 80-71-02, AND 71-00-00. OPS CHECKED GOOD. SDR UIEA2018012800117Seal · leakingOIL LIKE SUBSTANCE DRIPPING FROM APU AREA OF AIRCRAFT. PERFORMED AN APU LEAK CHECK IAW AMM 49-16-00-206-012, FOUND A LEAK FROM THE BEARING SEAL AREAS.SDR UIEA2018011900091Warning Message · false activationAFTER ENGINE START, THE LT OIL FILTER ADVISORY MESSAGE APPEARED FOR ONE MINUTE. THEN IT CONVERTED INTO A STATUS MESSAGE. TEMP IN CVG AT ENGINE START WAS -14C 7 DEG 7. IAW AMM 71-00-00, CONFIG 3, PAGE 271. ENGINE OPS NORMAL. AIRCRAFT OK FOR SERVICE.SDR UIEA2018011600082Lamp · inoperativeLEFT ENGINE VALVE DID NOT ILLUMINATE WHEN FUEL CONTROL MOVED FROM CUT OFF TO RUN. FOUND DEBRIS INSIDE OF THE LIGHT, CLEANED AND REPLACED THE LAMP, PRESS TO TEST OK,TESTED LEFT FUEL VALVE SOLENOID AND LIGHT IAW AMM 71-00-00, REMOVED AND REPLACED LT ENG VALVESDR UIEA2018011600069Pressure Switch · failedSTATUS MESSAGE FOR THE LT OIL FILTER. REPLACED THE OIL FILTER DIFFERENTIAL PRESSURE SWITCH ON THE NR 1 ENGINE IAW AMM 79-35-01, OPS CHECKED GOOD, NO LEAKS NOTED.SDR UIEA2018010700021Light · malfunctionedLEFT ENGINE SPAR VALVE LIGHT. REPLACED THE NR 1 FUEL SPAR VALVE LIGHT DRAWER ASSY IAW AMM 33-13-00. OPS CHECKED NORMAL.SDR UIEA2018010800036Warning Message · false activationSTATUS MESSAGE FOR THE LT OIL FILTER. CLEARED THE STATUS MESSAGE ,NO OTHER ISSUES NOTED IAW AMM 79-35-00.SDR UIEA2017123002447Pressure Switch · dirtyLEFT OIL FILTER STATUS MESSAGE DURING SHUTDOWN. CLEANED THE LT ENGINE DIFFERENTIAL PRESSURE OIL SWITCH. SYSTEM CHECKED GOOD IAW MM 79-35-00.SDR UIEA2017122802440Warning Message · false activationDURING LEFT ENGINE START, HAD A LT OIL FILTER EICAS MESSAGE DISPLAY. PERFORMED ENGINE RUN IAW AMM 71-00-00, MESSAGE CLEARED NO DEFECTS NOTED.SDR UIEA2017122402431Warning Light · false activationFLIGHT DECK TEMPPERATURE LIGHT ILLUMINATED ON OVERHEAD PANEL. PERFORMED FIM 21-61-00 FT 815 FOUND ZONE TEMP CONTROLL OPERATING NORMAL BITE CHECK OK AND VALVE FOLLOWS SWITCH IN FLIGHT DECK AND ON EICAS ECS PAGE.SDR UIEA2017122402430A/C Pack · inoperativeLEFT PACK INOPERATIVE IN ANY MODE.SDR UIEA2017112902333Warning Message · false activationSTATUS MESSAGE FOR THE RT ENGINE SPEED CARD. PERFORMED AN OPS CHECK OF THE NR 1 ENGINE SPEED CARD IAW FIM 73-21, FT 871 , MESSAGE CLEARED, OPS CHECKED NORMAL.SDR UIEA2017110802198Sensor · inoperativeRIGHT PACK INOPERATIVE IN AUTO AND STANDBY. REMOVED AND REPLACED RIGHT PACK CABIN AIR SENSOR IAW AMM 21-61-02.SDR UIEA2017102301997Duct · damagedFOUND A DAMAGE DUCT FOR THE RT PACK, THREADS ARE GONE AT SENSOR FOR THE RT COMPRESSOR OUTLET. REPLACED THE RT PACK OUTLET DUCT.SDR UIEA2017100601931Shutoff Valve · malfunctionedDURING CLIMB & DESCENT, LEFT PRESSURE VARIES & SURGES 10 PSI TO 40 PSI TO 10 PSI, OPERATES NORMALLY ON GROUND AND CRUISE. REMOVED AND REPLACED LG PRSOV IAW AMM 36-11-09, OPS CHECKED GOOD.SDR UIEA2017100301922Valve · failedDURING CLIMB OUT, 5000 FT THRU 15000 FT, THE LEFT DUCT PRESSURE SURGED FROM AROUND 40 PSI TO 10 PSI CONSTANTLY. DURING DESCENT, LEFT DUCT PRESSURE FLUCTUATED BY 30 PSI FROM 40 TO 10 PSI CONSTANTLY. SHUT THE LEFT PACK OFF TO MITIGATE SURGE. R & R PRV IAW ASDR UIEA2017100401926Warning System · activatedLT ENGINE BLEED OFF LIGHT ILLUMINATED. REF MDDR 89004 DUPLICATE WRITE UP. CLEARS MDDR 83993. PLACARDS REMOVED. MCC NOTIFIED.SDR UIEA2017100201914Valve · inoperativeLEFT ENGINE DUCT PRESSURE FLUCTUATED DURING CLIMB. REMOVED AND REPLACED FAMV, VALVE HANGS UP. LT FAMV HAS OPEN CIRCUIT BETWEEN CONNECTORS D2378A PIN 8A AND V343 PIN 1 IAW AMM 36-11-16. FAMV REACTIVATED, CLEANED ELECTRICAL TERMINAL STRIPS. FAMV CHANGED. OSDR UIEA2017100101908Valve · malfunctionedAFTER TAKEOFF, THE LEFT ENGINE BLEED STARTED SURGING BETWEEN 10 T0 30 PSI UNTIL FL 240, AND THEN STABILIZED. LEFT BLEED MATCHED WITH RIGHT IN CRUISE EACH WAYPOINT 35-40 PSI AT FL 360 NO EICAS MESSAGES OR STATUS MESSAGE. REPLACED FAMV AND CLEANED TERMINAL STRSDR UIEA2017092501854Module · malfunctionedAPU, NO BLEED AIR. REMOVED AND REPLACED FLOW SENSING MODULE, OPS CHECKED NORMAL IAW AMM 49-53-08.SDR UIEA2017092201791A/C Pack · surgesDURING DESCENT, THE LEFT PACK SURGED CONTINUOUSLY BETWEEN 20 AND 40 PSI. PERFORMED AN OPS CHECK, NO DEFECTS NOTED IAW AMM 21-51-00.SDR UIEA2017091501672Valve · faultedAFT CABIN TEMP EICAS DISPLAYED WITH AFT CABIN AUTO INOPERATIVE LIGHT ILLUMINATED DURING TAXI. REMOVED AND REPLACED THE AFT CABIN TRIM AIR VALVE ACTUATOR IAW AMM 21-61-07, OPS CHECKED GOOD.SDR UIEA2017091301645Switch · failedLEFT AFT BOOST PUMP INOPERATIVE. REMOVED AND REPLACED THE LEFT AFT BOOST PUMP PUSH BUTTON SWITCH IAW SWPM 20-84-18. SWITCH AND BOOST PUMP OPS CHECKED GOOD IAW AMM 28-00-00.SDR UIEA2017091201639Warning Message · false activationLEFT AFT FUEL PUMP MESSAGE, AMBER STATUS WHEN PUMP IS OFF. PERFORMED AN OPS CHECK IAW AMM 28-22-00. OPS CHECKED NORMAL.SDR UIEA2017091101631Seal · leakingDURING A DAILY INSPECTION, FOUND APU OIL LEAKING FROM THE OIL COOLER BYPASS VALVE. REMOVED AND REPLACED TWO SEALS IAW 49-27-10. NO LEAKS NOTED.SDR UIEA2017090301592Unknown · vibrationDURING DESCENT, WHEN ACFT HAS LEVELED AND AUTOTHROTTLES ARE ADVANCED FROM IDLE, THE ACFT EXPERIENCES AN AIRFRAME SHAKING & BOOM. UNABLE TO CONFIRM WHICH ENGINE, HOWEVER IT HAPPENED 3 TIMES DURING DESCENT. PERFORMED TROUBLSHOOTING IAW FIM 71-05 F/T 808, NO SDR UIEA2017081601492Unknown · malfunctionedRADAR SPIKING INTERMITTENTLY. OPS CHECKED WX RADAR IAW AMM 34-43-00, OPS CHECKED NML AT TIME.SDR UIEA2017081001450O-Ring · leakingRIGHT ENG OIL CAP O-RING LEAKING. REMOVED AND REPLACED THE RT ENGINE OIL TANK CAP O-RING IAW AMM 79-11-03, LEAK CHECKED OK.SDR UIEA2017080701425Fastener · looseNR 1 ENG VIBE MONITOR ERRATIC. INSP FOUND LOOSE HARDWARE & CLAMPS FRO ENG FAN, ACCELEROMETER T677 TIGHTENED. SECURED HARDWARE, RAN ENG. NO LONGER ERRATIC & WITHIN LIMITS IAW AMM 71-00-00, OPS CK GOOD.SDR UIEA2017073001381Valve · failedAFT CABIN TEMP EICAS MESSAGE DURING CRUISE. QRH COMPLIED WITH, ASSOCIATED AFT CABIN CONTROLLER INOPERATIVE. REMOVED AND REPLACED TRIM MODULATING VALVE IAW AMM 21-61-07, OPS CHECKED NORMAL.SDR UIEA2017072501303Detection Sys · inoperativeICE DETECTION AUTO INOPERATIVE. ICE DETECTION ON EICAS SYSTEM SHOULD HAVE BEEN OFF (+13C). PERFORMED OPS CHECK OF THE ICE DETECTION SYSTEM IAW AMM 30-81-00-715-017, OPS CHECKED GOOD.SDR UIEA2017072001250Skin · dentedTWO DENTS FOUND ON THE OUTBOARD NR 2 ENGINE NACELLE DURING A PREFLIGHT, WALKAROUND. ACCOMPLISHED PART ONE IAW EO #1971A145, PART 2 DVI EVERY 25 FLT CYCLES. PART 3 PERMANENT REPAIR PRIOR TO 1,000 FLT HRS.SDR UIEA2017071401219Shutoff Valve · malfunctionedLEFT ENGINE HPSOV EICAS MESSAGE ON LANDING, FOLLOWED BY A LT ENG HPSOV STATUS MESSAGE. REMOVED AND REPLACED HPSOV IAW AMM 36-11-07, OPS CHECKED GOOD IAW AMM 36-11-07.SDR UIEA2017071201145Fire Warning · false activationLT ENGINE FIRE LOOP 2 EICAS MESSAGE. ACCOMPLISHED FIM 26-11FT 805 AND TESTED IAW AMM 26-11-00-815-805. NO DEFECTS NOTED.SDR UIEA2017071301195Warning Light · illuminatedLEFT FWD FUEL PUMP PRESSURE LIGHT STAYS ILLUMINATED.SDR UIEA2017071201192Warning Message · false activationLEFT ENGINE HPSOV STATUS MESSAGE. PERFORMED ENGINE RUN FOR OPS CHECK OF HPSOV NO DEFECTS NOTED AT THIS TIME IAW MM 36-11-07.SDR UIEA2017071001136Actuator · failedAPU INLET DOOR CIRCUIT BREAKER TRIPPED. REPLACED THE APU DOOR ACTUATOR IAW 49-15-60. OPS CHECKED GOOD.SDR UIEA2017071001135Warning Light · false activationSTATUS FOR HIGH FLOW INHIBIT. OPS CHECKED IAW FIM 21-51 FAULT TREE 813. NO DEFECTS NOTED AT THIS TIME.SDR UIEA2017070701117Wire · openLEFT WINDOW HEAT EICAS MESSAGE. PERFORMED CONTINUITY CHECK FROM D4294J TO D1922, FOUND OPEN WIRE, BSD SPLICE ON WIRE W624-209R-24. IAW WDM 30-41-12. SPLICED THE WIRE IAW SWPM 20-30-12. PERFORMED OPS CHECK OF L2 WINDOW HEAT IAW AMM 30-41-00, OPS CHECKED GOOD.SDR UIEA2017063001079Starter · inoperativeAPU WILL NOT START. REMOVED & REPLACED THE STARTER MOTOR IAW AMM 49-41-004. OPS NORMAL,SDR UIEA2017062301053Ground Wire · disconnectedRIGHT ENGINE START VALVE LIGHT DIDN'T CYCLE DURING ENGINE START. ENGINE STARTED NORMALLY. FOUND GROUND TERMINAL DISCONNECTED, CONNECTED THE TERMINAL IAW SWPM 20-30-11, PERFORMED TEST 3 IAW MM 71-00-00. OPS CHECKED GOOD.SDR UIEA2017062001036Control Panel · malfunctionedRIGHT ENGINE START VALVE LIGHT DID NOT CYCLE DURING START. ENGINE STARTED NORMALLY. REMOVED AND REPLACED THE IGNITION AND STARTING PANEL IAW AMM 80-11-51. OPS CHECKED NORMAL.SDR UIEA2017061801033Generator · unknownAPU GENERATOR INOPERATIVE. OPS CHECK IAW AMM 49-11-00, OPS CHECK NORMAL.
Back to N1229A