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.
N3246TFears Edwin G III · Trafalgar, INN3246UGregory Group LLC · Norwalk, CTN3246XRouns Daniel L · Brady, MTN3247TBeeda Mark A · West Palm Beach, FLN3247VHentschel Ernest J · Galloway, NJN3248DPalmer Cade E · Eagle River, AKN3248SHanson Glen W · Anchorage, AKN3249MHyannis Air Service Inc · Hyannis, MAN3249UHutchison Roger R · Sioux Falls, SDN324FFMason Michael A · New Carlisle, INN324LULetourneau University · Longview, TXN324RHPhillips William L Trustee · E Hampton, MAN324RJSchelhorn Timothy J · Nampa, IDN324SVDavis Kyle R · Colleyville, TXN324YCesscon LLC · Yalesville, CTN3250JHigh Mesa Aviation LLC · Naturita, CON3250LMiner Jess L · Emmet, NEN3250U50 Uniform LLC · Traverse City, MIN3250YEonm182 LLC · El Paso, TXN3251DE S P Aviation LLC · Wilmington, DEN3251LWiles David A · Ozark, ARN3251YCarlson Andrew J · Ashville, NYN3252DQuigg Aircraft LLC · Muskegon, MIN3252LElizabethton Aerobatic Club Inc · Elizabethton, TNN3252SWhite Robert E · Woodlawn, TNN3252TFugfugosh Mahdi A · Castro Valley, CAN3252YPa1 208b-1088 LLC · Fort Lauderdale, FLN3253SCobb Darrell V · Corsicana, TXN3253VWilliams Cecil R · Clarksville, TNN3254CCoon Vernon Ray · Atmore, ALN3254JCarreiro Myriah L · Candia, NHN3254LSelby Thomas A · Fenton, MIN3254SAllen John C · Austerlitz, NYN3254UWright Ronald J · Olympia, WAN3254VRegistration Pending · Bolivar, MORegistration pendingN3255DAzul Aviation Inc · Fort Worth, TXN3255LPatton Steven W · Fayetteville, ARN3255QCorona Edgar O · Grants Pass, ORN3256JMyers Benny R · Wasilla, AKN3256TWoodfill Kyle · Lake Jackson, TXN3256YCowden Mark T · Kerrville, TXN3257DAlaska Dall Sheep Guides LLC · Anchorage, AKN3257EFlycarolina LLC · Concord, NCN3257LBeene Jerry · Bulverde, TXN3257SFelton Frank B III · Thorndale, TXN3257YGilbert Donald L Jr · Ligonier, PAN3258SRockwood Spa LLC · Houston, MON3258VBoard Of Trustees Of Western Michigan University · Battle Creek, MIN3258YByra Paula A · Pagosa Springs, CON3259DLutes Stacy J · Mooresville, NC
Back to AD 97-01-13