N21197
Service difficulty reports · 113
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 = 'N21197' 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 = 'N21197' 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 C2XA09SH247Bracket · wornSHV - DURING C-CHECK RT CENTER SPEED BRAKE TO WING BRACKET HAS MIGRATED BUSHING I/B SIDE OF BRACKET. MAINTENANCE REMOVED AND REPLACED RT CENTER SPEED BRAKE TO WING BRACKET IAW EMB-145XR AMM 20-10-01 AND SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SSDR C2XA09SH246Bracket · wornSHV - DURING C-CHECK RIGHT O/B GROUND SPOILER TO WING BRACKET HAS MIGRATED BUSHING I/B SIDE OF BRACKET. MAINTENANCE REMOVED AND REPLACED RIGHT O/B GROUND SPOILER TO WING BRACKET IAW EMB-145XR AMM 57-51-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH245Bracket · wornSHV - DURING C-CHECK RIGHT I/B GROUND SPOILER TO WING BRACKET HAS MIGRATED BUSHING ON O/B SIDE OF BRACKET. MAINTENANCE REMOVED AND REPLACED RIGHT I/B GROUND SPOILER TO WING BRACKET IAW EMB-145XR AMM 57-51-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH244Fitting · gougedSHV - DURING C-CHECK LT AILERON DAMPNER FITTING GOUGED. MAINTENANCE REMOVED AND REPLACED LT AILERON DAMPNER FITTING IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH243Bushing · migratedSHV - DURING C-CHECK LT GROUND SPOILER O/B HINGE I/B HAT BUSHING MIGRATED. MAINTENANCE REMOVED AND REPLACED LT GROUND SPOILER O/B HINGE I/B HAT BUSHING IAW EMB-145XR EC5740-01152 REV B. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH242Bushing · migratedSHV - DURING C-CHECK PAX DOOR MAIN SWING ARM UPPER ATTACH POINT UPPER AND LOWER HAT BUSHING MIGRATED. MAINTENANCE REWORKED PAX DOOR MAIN SWING ARM UPPER ATTACH POINT UPPER AND LOWER HOUSINGS AND INSTALLED NEW OVERSIZED HAT BUSHINGS IAW EC5210-01085 REV C. THSDR C2XA09RI083Relay · inoperativeFLIGHT 2236 - EWR - DURING APPROACH INTO EWR THE CREW REPORTED THAT THE "FADEC GOES INTO ETO WHEN THE LANDING GEAR IS LOWERED". THE AIRCRAFT LANDED AT EWR WITHOUT INCIDENT WHERE MAINTENANCE FOUND THE CONDITION TO BE A NORMAL OPERATION OF THE SYSTEM PER THE ROSDR C2XA09IA071Control Unit · faultyIAH - DURING CLIMB THE FLIGHT CREW REPORTED THAT THE MAIN PITCH TRIM WAS INOPERATIVE. THE AIRCRAFT RETURNED TO IAH AND LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE HORIZONTAL STABILIZER CONTROL UNIT TO CORRECT THE DISCREPANCY.SDR C2XA09IA019Engine · smokeIAH - FLIGHT 2371, THE CREW REPORTED A LAV SMOKE INDICATION ON EICAS AFTER TAKEOFF. THE ACFT RETURNED TO IAH AND LANDED WITHOUT INCIDENT. MX R&R THE NR 2 ENGINE, OPS TESTED WITH NO DEFECTS, AND THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA08ON119Flapper Valve · looseFLT 0422 - GEG - FLIGHT CREW REPORTED FUEL LEAKING FROM LEFT WING AT FL 340. ONT MX RESECURED LOOSE FLAPPER VALVE IN LEFT WING, OPERATIONALLY AND LEAK CHECKED SATISFACTORY. AIRCRAFT WAS RELEASED TO RETURN FOR SERVICE.SDR C2XA07SH069Floor Support · corrodedSHV - DURING C-CHECK, CENTER OMEGA BEAM CORRODED FR 20. MX REMOVED AND REPLACED CENTER OMEGA BEAM AT FR 20 DUE TO OUT OF LIMIT CORROSION. COMPLIED WITH EC 5320-0437 AND 5320-01140. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR C2XA06CL019Connector · looseCLE FLIGHT 3033 THE CREW REPORTED THE CABIN REAR CEILING EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE INSPECTED AND RECONNECTED THE CONNECTOR P8644 AT THE LIGHT ASSEMBLY. OPERATIONAL CHECKS WERE GOOD.SDR C2XA06CL014Pressure Valve · faultyTHE CREW REPORTED THE NR 2 ENGINE OIL PRESSURE IN AMBER AND INTERMITTENT RED IN FLIGHT. THE AIRCRAFT RETURNED TO DEPARTURE AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE INSPECTED AND REPLACED THE NR 2 ENGINE OIL TANK PRESSURE VALVE. OPERATIONAL CHECKS WER
Back to N21197