N7738A
Service difficulty reports · 255
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 = 'N7738A' 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 = 'N7738A' 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 SWAA2014120834808Hook · corrodedRIGHT OVERWING EMER ESCAPE ROPE LIFE LINE HOOK CORRODED AT FWD UPPER CORNER. R & R LIFE LINE IAW AMM.SDR SWAA2014120534699Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT STATION 92.70, 2ND FROM FWD VERTICAL STIFFENER. REPAIRED RIB IAW SRM.SDR SWAA2014060528726Cover · missingR1 DOOR EMER EXIT LIGHT COVER MISSING. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2013070517950Coffeemaker · faultyAFT COFFEE MAKER TURNED OFF & CIRCUIT BREAKERS PULLED WHEN SMELL OF BURNING RUBBER WAS NOTED. FOUND AFT GALLEY COFFEE MAKER NR 1 TO BE SOURCE OF ELECTRICAL SMELL. COMPLIED WITH SP2 IAW MOC & SPIB.SDR SWAA2013021312624Cover · missingEXIT SIGN COVER MISSING AFT SERVICE ENTRY DOOR. REPLACED MISSING EXIT SIGN COVER AT THE AFT SERVICE DOOR PER MM.
Back to N7738A