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.
N3134JOverton Asset Group LLC · St Marvs, IAN3134UBaine Larry A · Marne, MIN3134VShelley Cameron M · Reno, NVN3134XMachac Milton · Waller, TXRegistration expired, pending cancellationN3135CVeech Shawn M · Big Lake, AKN3135DSkycavu Inc · Hi Rls Mtn Pk, NMNon-citizen corporation, flight hours not reportedN3135EHerring Christopher E · Granbury, TXN3135QGrf Aviation LLC · Destin, FLN3135ULogue Christopher A · Trout Run, PAN3135XWilliams Vaughn E · Duncannon, PAN3136CPark Avenue Group Inc · Stuart, FLN3136FMurdock Lloyd W · Princeton, KYN3136JGriffith Charles B · Santa Maria, CAN3136QN3136q Flyers LLC · Las Vegas, NVN3136RKuntz Trucking Co · Gridley, ILN3136SSeiler Richard D · Bozeman, MTN3136YReed Jason B · Faith, SDN3137CKlausler Thomas W · Lakeville, MNN3137ERegistered aircraftN3137FJbm Endeavors LLC · Chewalah, WAN3137RGriffith Moseley Johnson & Associates Inc · Port Arthur, TXN3137SManley Robert E · Ferndale, WAN3137UCurson Randy J · Cape Coral, FLN3137YLopez Juan F Jr · Del Rio, TXN31381Strobridge Mark D · Bunnell, FLN3138CTurbo-Sphere Inc · Longmont, CON3138QShepard Donald · Lake Havasu City, AZN3138R15 Rides LLC · Manteo, NCN3138TJones Daniel D · Ekron, KYN3138URegistered aircraftN3138XBoardman Thomas M · Greenwich, NYN3139DGuichard Lawrence · Spokane, WAN3139QGrubbs Jerry M · Longview, TXN3139VArrow Trading Inc · Coconut Creek, FLN313BLDaggett Keith W · Rockport, MEN313DQIler Elden · Van Nuys, CAN313JHJam Three LLC · St George, UTN313JWWright George E Jr · Homestead, FLN313KDOdonnell Daniel Gordon · Plymouth, MAN313MPAlpha Bravo Charlie 1 Corp · Houston, TXN313RWSarp Rentals LLC · Loudon, TNN313SKJohnson Scott · Blaine, MNN313WTCinotto Robert L · Rhome, TXN3140CAthens William A · Missoula, MTN3140FWilliams Thomas G · Richland Center, WIN3140JSmith Franklin R Sr · York, SCN3140SLavell Michael J · Blue Mounds, WIN3140TSuggs Helen T · Jacksonville, FLN3140XGerasimov Gennady · Jefferson City, MON3140YParker Mccrum LLC · Eugene, OR
Back to AD 97-01-13