AD 97-01-13
Registered aircraft · 54,837
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
ORDER BY n_number"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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') ORDER BY n_number
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.
N20755Sale Reported · Wichita, KSSale reportedN20756Drew Kenneth R · Mineral Wells, TXN20757Johnson Mark B · Etna, CAN2075GReeves David G · Salmon, IDN2075JL & L Flying Inc · Glen Allan, MSN2075QHaugen'S Hangar LLC · Williston, NDN2075YCampbell Joseph M · Jay Em, WYN20761Hearty Pet Inc · Maugansville, MDN20763Meysenburg Daniel L · Columbus, NEN20767Cook Mike R · Rye, CON2076920769 LLC · Elbert, CON2076GOrman Rodger S · Murphys, CAN2076JEss Trent E · Loretto, MNN2076QGreen Jason A · Omaha, NEN2076RBhms Air LLC · Miami, FLN2076XStumm Robert W · Cadott, WIN2076YOsteen Richmond S · Hendersonville, NCN2076ZHyer Lindsay C · Jacksonville, NCN20770Trenkle Charles D · Long Beach, CAN20771Cussen George J · Mount Prospect, ILN20774S & J LLC · Albany, MON20777Marthew Aviation LLC · Rochester, MIN2077GSharp Robert M Trustee · Jenks, OKN2077QDirks Darrel · Marienthal, KSN20785Villa Axel · Orlanda, FLN20786State Of Alaska · Anchorage, AKN20789Johnson Laurel D · Newcastle, WAN2078GCasaus Santos · Rio Rancho, NMN2078RCustom Aviation LLC · Butler, PAN2078YBell Jason S · Coos Bay, ORN2078ZLockhart Flying Club · Lockhart, TXN20791L A M Capital Management LLC · Sheridan, WYN20792Boyette Donnie R · Kenly, NCN20793Bas Part Sales LLC · Greeley, CON20797N20797 LLC · Odessa, FLN2079GStaiano Salvatore G · Flemington, NJN2079QMkk Pilots LLC · Media, PAN2079ZSpitler Scott M · Maryville, TNN207BHElevation Squad Inc · York, PAN207CCAbaco Fire Rescue Association Inc · Lewes, DEN207CHAviation Trust Co LLC Trustee · Oklahoma City, OKN207CZBig Sky Aviation Inc · Wilmington, DEN207DAKolb Austin · Phoenixville, PAN207DDHillyard Robert Keith · Dallas, TXN207DFDouble R Air LLC · Miami, FLN207DGRwr Air Inc · Tok, AKN207DLRegistered aircraftN207DRRadicke Dixie A · Uvalde, TXN207FDElevation Squad Inc · York, PAN207GAngry Dragon LLC · St Thomas, VI
Back to AD 97-01-13