N7886A
Service difficulty reports · 254
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 = 'N7886A' 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 = 'N7886A' 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 SWAA2022020427950Support Fitting · brokenPANEL 192E FWD LH AND RH SUPPORT FITTING ARE BROKEN / REMOVED & REPLACED PANEL 192 E; FWD. L/H & R/H FUSELAGE SUPPORT FITTINGS IAW 737-700 SRM 51-40-02-0G-0 & AIPC 53-12-11-25.SDR SWAA2018011919200Window Frame · crackedFLIGHT DECK, L3 WINDOW FRAME E-F POST FOUND TO BE CRACKED IN THE SECOND LOWER FASTENER HOLE. REPAIRED THE WINDOW POST IAW ACO.SDR SWAA2018011819179Window Frame · crackedFLIGHT DECK R1 WINDOW FRAME FOUND TO BE CRACKED THROUGH AT UPPER OUTBOARD CORNER. REPAIRED THE WINDOW FRAME IAW ACO.SDR SWAA2018011819155Post · crackedRT NR 3 WINDOW FRAME E-F POST CRACKED IN THE 2ND AND 4TH LOWER FASTENER HOLES. REPAIRED POST IAW ACO.
Back to N7886A