AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N8337UHaeffner Christopher M · Saint Peters, MON8337XMckay Jim · Camden, TNN8338Aviation Hub Inc Trustee · Cheyenne, WYN8338AWoodbury Forest P · Clarksville, TNN8338BSmitty172 LLC · Rockford, MIN8338LTreimer Aviation LLC · Davenport, IAN8338TOhair Mitchell · Temecula, CAN8338USchnell Brothers Aviation LLC · Kalispell, MTN8338XSkiatook Flying Club LLC · Skiatook, OKN8338ZNistler Ben · Bozeman, MTN8339BSmith Daniel B · Boonville, NCN8339LRohrbaugh David J · Oakland, MDN8339UDrouet Douglas T · Eugene, ORN833CBDehaan David J · San Diego, CAN833CGParagon Air Group · Fort Worth, TXN833CPCivil Air Patrol · Maxwell Afb, ALN833EREmbry Riddle Aeronautical University · Daytona Beach, FLN833KXHillsboro Aero Academy LLC · Hillsboro, ORN833MAState Of Wisconsin · Madison, WIN833SATimmcke Alan E · Tampa, FLN833TWDesert Wind Wings LLC · Mesa, AZN8340AWeyers William C · Grimes, IAN8340LHess Garrett J · Fullerton, CAN8340MBlake Larry Q · Suwanee, GAN8340QFly8ma LLC · Big Lake, AKN8340TSopris Aviation LLC · Carbondale, CON8340ZInstant Equity Auto LLC · Boise, IDN8341BColeman Patrick D · Naperville, ILN8341MKab Aviation LLC · Cassopolis, MIN8341TSolum Edwin H · Spokane, WAN8342BShelton Harold G · Christiansburg, VAN8342MStreeter Wyatt E · Hanford, CAN8342SSkydive Northstar LLC · Mankato, MNN8342THoffmann John M · Applegate, MIN8342XRoberts Jeremy C · Winchester, OHN8343MDuke Kay L · Darrouzett, TXN8343SMcgowan Jon G · Northfield, MAN8343XHoward John D · Springfield, OHN8343ZBybee Don R · La Center, WAN8344GDonat Brandon L · Glendale, AZN8344LHeir Borne Flying Club Inc · Minot, NDN8344SDouble Nickel Recycling LLC · Perryville, MON8344TUrish Jay T · Mckinney, TXN8344ZMccoy Dell K · Aurora, ILN8345MBryant William G · Kenai, AKN8345QKatahdin Air Service Inc · Hermon, MEN8345SOlsen H Peter Jr · Fallon, NVN8345U45u Leasing LLC · Beavercreek, OHN8346GN8346g LLC · Fort Pierce, FLN8346JHodgman Robert J · Yakima, WA
Back to AD 79-10-14 R1