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.
N2534YTorres Gerardo · Gurabo, PRN25351Russell Robert Q · Genoa City, WIN25357Jameson George T · Auburn, MAN25359Kelly John M · Gastonia, NCN2535QDerodeff Stephan A · Nipomo, CAN2535VRegistration Pending · Fort Worth, TXRegistration pendingN2535YFleck Timothy · Hurst, TXN25362Sunrise Aviation Inc · Ormond Beach, FLN2536GDittmer Larry J · Basco, ILN2536LLink Kim D · Golden Valley, NDN2536QWiebe Tim · Newton, KSN2536UNeal Tommy G · Sulphur Springs, TXN2537GDirigo Aviation LLC · York, MEN2537KPanuski Christopher Louis · Davidson, NCN2537LOneill Timothy J · Clyo, GAN2538JWatts Noah D · San Antonio, TXN2538R1 Point 21 Gigawatts LLC · Auburn, WAN2538UHall Chad B · Baytown, TXN2538VDavidson Joel R · Granville, NYN2538YChapman James Tod · Portland, ORN25393Oliver Blake H · Talbotton, GAN25399Hudson Donald L · Camarillo, CAN2539RWillard John E Jr · Rockwood, MEN2539ULoes Todd A · Waterloo, IAN2539YOly LLC · Onida, SDN253DFFort Greg R · Burien, WAN253ERFreeman Joshua A · Platteville, CON253NANeidert Melvin E · Ulysses, KSN253RAReynolds Darryl G · Wills Point, TXN253RRRoland Ronald W Trustee · Mckinney, TXN253TATalon Air Service Inc · Soldotna, AKN25408Thompson David J · Pemberton, NJN2540RFreeman Josh · Turtle Lake, NDN25413Dreamair Aviation Inc · Boca Raton, FLN25416Mikes Aircraft Shop Inc · Corpus Christi, TXN2541GDuvall Paul M · Scottsburg, INN25426American Aviation Inc · Brooksville, FLN2542RThordarson Gudsteinn T · La Porte, INN2542SSierra Systems LLC · Emigrant, MTN2542UDoak Ronald E · Reno, NVN25430G And M Aircraft Inc · Wheatridge, CON2543RSaddlery Air Inc · Des Moines, IAN2544GEnsman Enterprises LLC · Chino Valley, AZN2544RBill Church Real Estate LLC · Midland, MIN2544YChristianson Cleet M · Enumclaw, WAN2545GSpokane Turbine Skydiving LLC · Medical Lake, WAN2545RYad Aviation LLC · Cherry Hill, NJN2545YCalifornia Aviation Services Inc · Riverside, CAN2545ZBjorn-Roli Per Erik · Anchorage, AKN25467Reynolds Financial Inc · Tyler, TX
Back to AD 97-01-13