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.
N30239Jones Gary E · Orange, CAN3023FJones Clinton D · Santa Rosa Beach, FLN3023SSynnes Dale C · Santa Paula, CAN3023YMorgan Lee Blanchard · Albuquerque, NMFirst renewal noticeN3024FSutton Aircraft Salvage LLC · Palmer, AKN3024XDavis James M · Tuscaloosa, ALN3024YTemple Curtis Lee · Porcupine, SDN30250O'Connor Sean J · Newburyport, MAN3025FWarner Daniel M · Fremont, OHN3025SHummer Bryant C · Garden Plain, KSN3025UEddy Bruce A · Winfield, ALN3026FMock1 LLC · Abingdon, VAN3026JRoberts James D Trustee · Omaha, NEN3026QSuper D Group LLC · Hanoverton, OHN3026SSolewin Kimberly M · Christoval, TXN3026VNew Mexico Flying Eagle Inc DBA · Tucson, AZN3026YEpss LLC · Tavernier, FLN30275Tomlinson Douglas F · Waunakee, WIN30278Barron Joseph M · Des Moines, IAN3027FSale Reported · Watford City, NDSale reported, pending cancellationN3027XSchneider Benjamin J · Wheeling, WVN30285Galena City School District · Galena, AKN3028QAllenspach Timothy L · Stillwater, MNN3028VChildress Sam · Weatherford, TXN3028XFicken Jerome L · Cedar Hill, MON3028YStanton Tod J · Naperville, ILN30293Advantage Aviation Services LLC · South Saint Paul, MNN30297Siers Richard · Ocean Shores, WAN3029JSorrells Brandon L · Yuma, AZN3029QOzarks Auto Show Inc · Hollister, MON3029SBlawusch Richard K · Waterloo, WIN3029VFlyt LLC · Madison, MSN3029XRegistered aircraftN302AZavoina Lawrence D Jr · Roanoke, TXN302DBHouston Chet H · Beaufort, SCN302GPInternational Air Services Inc Trustee · Carson City, NVN302JAAviate LLC · Green Bay, WIN302MJ425 Partners LLC · Guymon, OKN302USolomon Mark Trustee · Wilmington, DEN30302Kamenar Service LLC · Mukwonago, WIN30303Registration Pending · Meeker, CORegistration pendingN30304Williams Rod · Atascadero, CAN30307Johnston Phillip Jr · Pensacola, FLN30308Griffith Scot E · Glendale, AZN3030EElon Aviation LLC · Burlington, NCN3030FThirty Thirty Club · Lebanon, ORN3030UAll Around Inc · Ramseur, NCN3030VSanders Flight Training Center Inc · Jasper, ALN3030YSamaniego Alejandro · Tucson, AZN30311Parker Yates · Wellington, TX
Back to AD 97-01-13