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.
N2063QAv8ors LLC · Port Orange, FLN20640Cahoon Neil T · Camas, WAN20648Jones Farm Fresh LLC · Bartlett, TNN2064GGarcia Edward O · Hereford, AZN2064XCurtin Andrew J · Fernandina Beach, FLN2064YRocheleau Adam A · Anchorage, AKN20652H J H Aviation LLC · Gordo, ALN2065GZach Matthew L · Oconomowoc, WIN2065ZBorn Stephen R · Yucaipa, CAN20660Jl Avn LLC · Ontario, OHN20665Millais Alan K · Sacramento, CAFirst renewal noticeN2066620666 Aircraft Leasing LLC · Spanish Fork, UTN20667Wojtowicz Diane L · Perry, NYN20668Safety In Motion Flight Center · Puyallup, WAN2066GLatofski-Jeffries Gustavo Enrique · Mcallen, TXN2066JKlein Flying Service Inc · Lawrenceville, ILN2066ZGrand Flying Club Inc · Redding, CAN20670Stearns Edwin B Jr · Eloy, AZN20675First Flight Corp · San Diego, CAN20676Firstflight 33 LLC · Jacksonville, FLN2067GYeager Hal J · Winterset, IAN2067XPank Thomas E · Walkersville, MDN2067YShankle Christopher · Orlando, FLN20689Lessard Timothy F · Monmouth, MEN2068RSix Lima Papa LLC · Kalispell, MTN2068SN2068s LLC · Solana Beach, CAFirst renewal noticeN2068YFurchtenicht Corey L · Sarona, WIN2068ZThompson Jeffrey A · Bishop, CAN20693Celestial Kinetics Flight Academy LLC · Waupaca, WIN20697Schneidman Barry · Raleigh, NCN2069BCopper Mountain Aviation LLC · Anchorage, AKN2069RLazy T Aviation LLC · Ashland, NEN2069WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2069XFrance Frederick M · Gales Ferry, CTN2069ZMiller Scott A · Norwood, MON206ARCanoe Bay Outfitters LLC · Port Alsworth, AKN206AYOno Yutaka · Torrance, CAN206BABoeing Company · Mesaon, AZN206BLWright Kim B · Anchorage, AKN206BRWest Matthew Shawn · Island, KYN206BSBlue Star Gas Fleet Services Co · Central Point, ORN206CTDe Creeft Joseph M · Homer, AKN206DP W Feenstra Construction Inc · Queen Creek, AZN206DCAri Air LLC · Anchorage, AKN206DJAlum I Tank Inc · Harvard, ILN206DMBushwood Air LLC · Coeur D Alene, IDN206DZEvans David J · Parker, CON206EJSzymanski Collin Andrew Sr · Anchorage, AKN206EKKoch & Koch Inc · Grass Valley, CAN206ELAir Tuna LLC · Homestead, FL
Back to AD 97-01-13