N123HQ
Service difficulty reports · 119
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 = 'N123HQ' 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 = 'N123HQ' 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 R61A201311161190Line · corrodedDURING HEAVY CHECK, LT WING FUEL PRESSURE LINE FOUND CORRODED. R & R FUEL PRESSURE LINE IAW AMM 20-10-13.SDR R61A201311161189Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT TUBE FOUND CORRODED. MX R & R RT WING FUEL VENT TUBE IAW AMM 20-10-13.SDR R61A201311161188Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT TUBE FOUND CORRODED. R & R RT WING FUEL VENT TUBE IAW AMM 20-10-13.SDR R61A201311161187Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT TUBE, FOUND CORRODED. R & R RT WING FUEL VENT TUBE IAW AMM 20-10-13.SDR R61A201311161186Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT TUBE FOUND CORRODED. R & R RT WING FUEL VENT TUBE IAW AMM 20-10-13.SDR R61A201311161185Line · corrodedDURING HEAVY CHECK, LEFT WING FUEL VENT LINE FOUND CORRODED. MX R & R FUEL VENT LINE IAW AMM 20-10-13.SDR R61A201311161184Line · corrodedDURING HEAVY CHECK, LT WING FUEL VENT LINE FOUND CORRODED. R & R FUEL VENT LINE IAW AMM 20-10-13.SDR R61A201311161183Line · corrodedDURING HEAVY CHECK, LT WING FUEL VENT LINE FOUND CORRODED AT FLANGE. R & R FUEL VENT LINE IAW AMM 20-10-13.SDR R61A201311161182Line · corrodedDURING HEAVY CHECK, LT WING FUEL VENT LINE FOUND CORRODED AT FLANGE. R & R FUEL TUBE WITH SERVICABLE IAW AMM 20-10-13.SDR R61A201311161181Tube · corrodedDURING HEAVY CHECK, LT WING FUEL VENT PLUMBING LINE CORRODED AT FLANGE. MX R & R WITH SERVICEABLE TUBE IAW AMM 20-10-13.SDR R61A201311161180Line · corrodedDURING HEAVY CHECK, LT WING FUEL VENT LINE FLANGE CORRODED. R & R FUEL TUBE IAW 20-10-13.SDR R61A201311161179Line · corrodedDURING HEAVY CHECK, LT WING FUEL VENT LINE FOUND CORRODED ON FLANGE. R & R FUEL VENT LINE IAW AMM 20-10-13.SDR R61A201311161178Line · corrodedDURING HEAVY CHECK, LT WING FUEL VENT LINE FOUND CORRODED. R & R FUEL VENT LINE IAW WITH AMM 20-10-13.SDR R61A201311161177Line · corrodedDURING HEAVY CHECK, LT FUEL VENT LINE FOUND CORRODED. R & R FUEL LINE IAW AMM 20-10-13.SDR R61A201311161176Line · corrodedDURING HEAVY CHECK, LT FUEL VENT LINE FOUND CORRODED. R & R FUEL LINE IAW AMM 20-10-13.SDR R61A201311161175Line · corrodedDURING HEAVY CHECK, LT WING FUEL VENT LINE FOUND CORRODED. R & R FUEL LINE IAW AMM 20-10-13.SDR R61A201311161174Line · corrodedDURING HEAVY CHECK, FUEL VENT LINE IN LT WING FOUND CORRODED. R & R LINE IAW AMM 20-10-13.SDR R61A201311151193Line · corrodedDURING HEAVY CHECK, FOUND RT WING FUEL FEED LINE CORRODED. R & R FUEL FEED LINE SLEEVES AND COUPLINGS IAW AMM 20-10-03.SDR R61A201311151192Line · corrodedDURING HEAVY CHECK, FOUND FUEL FEED LINE CORRODED. R & R FUEL FEED LINE IAW AMM 20-10-13.SDR R61A201311141194Threshold · corrodedDURING HEAVY CHECK, FWD CARGO DOOR LOWER THRESHOLD HAS CORROSION AROUND NUTPLATES THAT CHROME BUMPER ATTACHED TO CORODED ON THE FWD BUMPER ANGLE BRACKET AFT BUMPER BRACKET HAS CORROSION ALSO. R & R CORRODED NUTPLATES.SDR R61A201311121150Gusset · corrodedDURING HEAVY CHECK, RT GUSSET CORRODED AT FRAME BS 87. MX REMOVED RT GUSSET, MATCH DRILLED NEW AND INSTALLED IAW SRM 51-41-00, 51-41-01.SDR R61A201311101214Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE FOUND CORRODED. MX R & R FUEL VENT LINE IAW AMM 20-10-13.SDR R61A201311101213Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE FOUND CORRODED. MAINTENANCE R & R FUEL VENT LINE IAW AMM 20-10-13.SDR R61A201311101212Line · corrodedDURING HEAVY CHECK, LT WING FUEL FEED LINE FOUND CORRODED. MAINTENANCE R & R FUEL LINE IAW AMM 20-10-13.SDR R61A201311101211Line · corrodedDURING HEAVY CHECK, LT WING FUEL FEED LINE FOUND CORRODED. R & R FUEL LINE IAW AMM 20-10-13.SDR R61A201311101209Line · corrodedDURING HEAVY CHECK, RT WING FUEL FEED LINE CORRODED. R & R FUEL FEED LINE IAW AMM 20-10-03.SDR R61A201311101208Line · corrodedDURING HEAVY CHECK, RT WING FUEL FEED LINE CORRODED. R & R FUEL FEED LINE IAW AMM 20-10-03, 20-10-13.SDR R61A201311101207Line · corrodedDURING HEAVY CHECK, RT WING FUEL FEED LINE CORRODED. R & R FUEL FEED LINE IAW AMM 20-10-03, 20-10-13.SDR R61A201311101206Line · corrodedDURING HEAVY CHECK, RT WING FUEL FEED LINE CORRODED. R & R FUEL FEED LINE IAW AMM 20-10-03, & 20-10-13.SDR R61A201311101205Line · corrodedDURING HEAVY CHECK, RT WING FUEL FEED LINE CORRODED. R & R FUEL FEED LINE IAW AMM 20-10-03, 20-10-13.SDR R61A201311101204Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R FUEL LINE IAW AMM 20-10-03, & 20-10-13.SDR R61A201311101203Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R FUEL LINE IAW AMM 20-10-03, & 20-10-13.SDR R61A201311101202Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R FUEL LINE IAW AMM 20-10-03, 20-10-13.SDR R61A201311101201Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R RT WING FUEL LINE IAW AMM 20-10-03, & 20-10-13.SDR R61A201311101200Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R RT WING FUEL LINE IAW AMM 20-10-03, & 20-10-13.SDR R61A201311101199Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R RT WING FUEL LINE IAW AMM 20-10-03, & 20-10-13.SDR R61A201311101198Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R RT WING FUEL LINE IAW AMM 20-10-03, 20-10-13.SDR R61A201311101197Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R RT WING FUEL LINE IAW AMM 20-10-03 AND 20-10-13.SDR R61A201311101196Line · corrodedDURING HEAVY CHECK, RT WING FUEL VENT LINE CORRODED. R & R FUEL VENT LINE IAW AMM 20-10-03.SDR R61A201311101195Clamp · corrodedDURING HEAVY CHECK, RT WING CLAMPS AND SLEEVES ARE CORRODED ON FUEL LINES. R & R CORRODED CLAMPS AND SLEEVES IAW AMM 20-10-13.SDR R61A201311091215Coupling · corrodedDURING HEAVY CHECK, MICROBIAL GROWTH FOUND IN LT WING FUEL LINES, CLAMPS CORRODED FROM GROWTH. FUEL LINE INSTALLS, ALL CLAMPS R & R IAW AMM 20-10-13, PN 14C16-16A.SDR R61A201311091126Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STAB LEADING EDGE SECOND MOST INBOARD RIB IS CRACKED. R & R RIB IAW SRM 51-40-02.SDR R61A201311091125Bolt · corrodedDURING HEAVY CHECK, LT MLG MIDDLE GEAR DOOR CENTER LOWER MOUNTING BOLT AND BARREL NUT ARE CORRODED. MX R & R BOLTS AND NUTS IAW AMM 32-12-04.SDR R61A201311071216Structure · corrodedDURING HEAVY CHECK, POSSIBLE CORROSION FOUND AROUND WASTE DUMP BOX. MX COMPLIED WITH SB 175-53-0095 NO FURTHER DEFECTS NOTED.SDR R61A201311071151Exhaust Duct · corrodedDURING HEAVY CHECK, APU EXHUST COLLECTOR CORRODED AROUND BOLTS AND SEAMS EXHUST LEAK ON SEAM. MX R & R CORRODED HARDWARE ON APU EXHAUST COLLECTOR IAW 20-10-01, REMOVED REMAINING CORROSION IAW SRM 51-12-02. PN NAS6703U2 BOLT. ACFT REMAINS UNTIL COMPLETION OSDR R61A201311071129Seal Depressor · corrodedDURING HEAVY CHECK, AFT CARGO DOOR LOWER CENTER SEAL DEPRESSOR CORRODED IN CENTER STRIP AND SEVERAL AREAS AROUND NUT PLATES. R & R SEAL DEPRESSOR IAW SRM 51-40-02, 51-41-01.SDR R61A201311071128Seal Depressor · corrodedDURING HEAVY CHECK, AFT CARGO DOOR LOWER CORNER SEAL DEPRESSOR CORRODED ON TOP EDGE. MX R & R SEAL DEPRESSOR IAW AMM 20-10-01, SRM 51-40-02.SDR R61A201311071127Wire Harness · corrodedDURING HEAVY CHECK, CORROSION FOUND ON LOWER BEACON WIRE HARNESS SHIELDING. MX R & R WIRE HARNESS IAW SWPM 20-51-00, SWPM 20-50-10.SDR R61A201311061154Seat Track · damagedDURING HEAVY CHECK, LT SEAT TRACK HAS TOOL DAMAGE AND CORROSION. MX R & R DAMAGED SEAT TRACK IAW SRM 51-41-01, 51-41-02, 51-43-02.SDR R61A201311061153Bellcrank · corrodedDURING HEAVY CHECK, AFT PASSENGER DOOR SLIDE MECHANISM CABLE END TO BELLCRANK HARDWARE CORRODED. MX R & R CABLE TO BELLCRANK ATTACHING HARDWARE IAW AMM 52-12-40.
Back to N123HQ