N634AS
Service difficulty reports not matched to an aircraft · 107
They name N634AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N634AS' AND registry_match IS NULL 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 = 'N634AS' AND registry_match IS NULL 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 ASOA99083Engine · failedEN ROUTE TO ATL, LEFT ENGINE OIL PRESSURE DROPPED TO 0 PSI. CAPTAIN PERFORMED ENGINE FAILURE IN FLIGHT CHECKLIST, DECLARED AN EMERGENCY, AND PERFORMED A SAFE SINGLE ENGINE LANDING AT CSG. MCN MAINTENANCE CREW FOUND NR 3/4 BEARING OIL TUBE CRACKED. MAINTENANSDR 98ZZZM400Fitting · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED STRINGER NR 16 RT END FITTING CORRODED AT FRAME 27 RT. INSTALLED NEW STRINGER END FITTING IAW ASA EO 72-53-0046. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM399Seat Track · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED RT MIDDLE OUTBOARD SEAT TRACK CORRODED. INSTALLED NEW RT MIDDLE OUTBOARD SEAT TRACK IAW ASA EO 72-53-0044. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM398Seat Track · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED LEFT FA SEAT TRACK CORRODED. INSTALLED NEW LEFT FA SEAT TRACK IAW ASA EO 72-53-0043. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM397Seat Track · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED RT INBOARD MIDDLE SEAT TRACK CORRODED. INSTALLED NEW RT INBOARD MIDDLE SEAT TRACK IAW ASA SRM 51-25-04 AND EO 72-53-0044. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM395Seat Track · corrodedSAW - DURNG C-CHECK INSPECTION, MAINTENANCE REPORTED RT FA SEAT TRACK CORRODED. INSTALLED NEW RT FA SEAT TRACK IAW ASA EO 72-53-0043. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM396Seat Track · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED LEFT OUTBOARD AFT SEAT TRACK CORRODED. INSTALLED NEW LEFT OUTBOARD AFT SEAT TRACK IAW ASA EO 72-53-0044. AIRCRAFT RETURNED TO SERVICE. (M)
Back to N634AS