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.
N151PBParker Scott L · Midland, TXN151PZMarvin Neil · Seattle, WAN151VUVincennes University · Indianapolis, INN1520YScott Thomas A Jr · Lawrenceburg, TNN1521CMacdougall Glen H · Salisbury, MAN1521HHopkins John C Jr · Tallulah, LAN1521VBlack Hill Consulting LLC · Lake Havasu City, AZN1522CKruse Adam L · Weiser, IDN1522VDawn Patrol Flying Club Inc · Northville, MIN1522YKinard Phillip · Tuscaloosa, ALN1523FGray Rex Lee · Palmer, AKN1523QKuharske Jeffrey · Groveland, FLN1523VSchmitz Barbara B · Oshkosh, WIN1523YRegional Air Inc · Lawton, OKN1524QAnderson Anton E · Loves Park, ILN1525HKubasch Kevin M · Longville, MNN1526FRegistered aircraftN1526HThompson Roy Dayton · Bulverde, TXN1526QTurpin George · Maquoketa, IAN1526VRl Aviation LLC · Miami, FLN1527GHanley Thomas W · Kissimmee, FLN1527YEshman Daniel J Jr · Bryan, OHN1528YTexoma Aero Club · Denison, TXN1529CBellows Paul F · Vancouver, WAN1529FLloyd David M · Grants Pass, ORN1529YBirge Darrell W · Linden, INN152APGood Life Aviation LLC · San Tan Valley, AZN152AWYouth Missions Aviation Academy Inc · Southlake, TXN152AZRegistration Pending · Long Beach, CARegistration pendingN152BBJensen Harold G · San Antonio, TXN152BJMissionaire LLC · Kennedy, NYN152BMPluska Paul · Hansville, WAN152BPBaker John A · Cape Coral, FLN152BTCoho Aviation LLC · Hillsboro, ORN152BUGreen Airport Development Corp · Kemah, TXN152CJFoss Fred C · Naperville, ILN152DMHolladay Aviation LLC · Jacksonville, FLN152DXCastracane Mark A · Hattiesburg, MSN152DZPopovitch Michael P · Marina, CAN152EF47 North Aviation LLC · Wenatchee, WAN152ERAviat Aircraft Inc · Afton, WYN152FASomnium Volans LLC · Walton Hills, OHN152FCNygren Shad · Fallon, NVN152GBHillsboro Aero Academy LLC · Hillsboro, ORN152GFBright Shaji · Martinez, GAN152GSBitondo Steven S · Mamaroneck, NYN152GTHansen Nelse · Lawrenceville, GAN152HFBaier Dale Edwin · Colleyville, TXN152HRWarner James A · Watertown, NYN152HWWuertz Errol Gene Jr · Mcpherson, KS
Back to AD 97-01-13