AD 75-01-07
Registered aircraft · 2,118
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:75-01-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-01-07')
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:75-01-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-01-07') 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.
N24183Smither Tom M · Marietta, GAN24195Barrett Group LLC · Farwell, TXN242FFThomas Leslie R · Kosse, TXN242SFCurtin Christopher C · Ashburn, VAN2435ACooper Timothy J · Spearman, TXN244JNShepherd Jacob · Lake Havasu City, AZN2458ALeger Bryan · Gulf Breeze, FLN246WBToavs Brent J · Wolf Point, MTN249BB42m Aviation LLC · Shady Shores, TXN24AGAegis Air LLC · Columbia City, INN24JVVan Blarcom John C II · Highland, CAN24LSickels Henry C · El Cajon, CAN24WKCannizzaro Charles DBA · North Syracuse, NYN250GWasalo And Luby Air LLC · La Fayette, GAN250TCGroth William B · Hixson, TNN25632Struck Larry G · Gardnerville, NVN25633Paolercio Alan D · Grants Pass, ORN25662Atcnavion LLC · Hinckley, OHN25717Vaadi LLC · Babson Park, FLN25719Brunner Robert L · Jefferson, ORN258TCDunn Mark A · Lufkin, TXN259JHall James A · Bozeman, MTN259TTaylor Ted H · Corsicana, TXN25BTFernandez Sergio R · Port Saint Lucie, FLN25VBOtto Aircraft Sales Inc · Sarasota, FLN260AACarpenter Timothy A · Phoenix, AZN2667Marlow Air LLC · Gilmanton Iw, NHN266PDLiberty Garden Center Inc · Norwich, NYN2682AAnacortes Associates LLC · Anacortes, WAN2701TGray Stephen T · Lafayette, CAN2714TVertical Flight Leasing LLC · Wilmington, DEN2717AMitchell Matthew · Roanoke, TXN2720TMiller Mark · Bellevue, WAN2721TGalvin Peter · Laytonsville, MDN2722AMontgomery Douglas Tanner · San Antonio, TXN2728TMilk Ranch LLC · Stephenville, TXN2729TWasileski David J · Auburn, NYN272MSHinkle Paul · Broken Arrow, OKN272SBofinger Jr John M · Hewitt, NJN2731TFocus LLC · Missoula, MTN2735TWhite Michael W · Key Largo, FLN2736TM & N Leasing Co · Marietta, GAN2739TPickering Kevin P · Lakeland, TNN2740AMcdaniel Joseph Stewart II · Henderson, TXN2746TFranklin Ronald C · Las Vegas, NVN2749TCaudle Nathan · Fort Worth, TXN274HSWebb Alan J · Medford, ORN274SScott Joseph Brian · Sarasota, FLN2753AThomas Dale A · Gooding, IDN27550Anderson Herman A · Basalt, CO
Back to AD 75-01-07