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.
N9296HSmith Richard A · Burnsville, MNN9296XJasuma Farms · Maxwell, CAN92970Elizabeth City State University · Elizabeth City, NCN9297TSutton Aircraft Salvage LLC · Palmer, AKN9297UNorthwest Wings LLC · Hillsboro, ORN9297XJohnson Durwood D · Beaumont, TXN9298AHenderson Larry V · Highland Village, TXN9298GA&A Aviation LLC · Mountain Brk, ALN9298ZFrederick Ag LLC · Humboldt, KSN929AEColman Steve · Alamosa, CON929BMSuntops Aircraft Holding LLC · Lakeland, FLN929FRacoon Aviation LLC · San Antonio, TXN929LSFlying Tigers Flight School Ltd · Houston, TXN929PMRegistered aircraftN929RHJohnson Merlin K Trustee · Mentone, CAN92ATBroquet Bruce L · Anchorage, AKN92CRodriguez Michael C · Drums, PAN92CCCanadian Co Sheriffs Office · El Reno, OKN92CMN92cm LLC · Genola, UTN92CPSlattery Richard E · Fountain Valley, CAN92DCAdams Bob L · Eagle River, AKN92DSBooty Bill · Idaho Falls, IDN92DWBurnette Jeffrey T · Big Lake, AKN92FRGliem Robert E Jr · Eddystone, PAN92FSEastern Kentucky University · Richmond, KYN92HFHeritage Asset Leasing LLC · Ronkonkoma, NYN92LCEastern Kentucky University · Richmond, KYN92MMAircraft Guaranty Corp Trustee · Oklahoma City, OKN92NAOneill Laurie A · Pinckney, MIN92RHCrabtree Nathan J · Boise City, OKN92SCMorrison Neil E · Port Townsend, WAN92WMGerhardt David C · Denver, CON9300BBenson Ryan Denson · New Carlisle, OHN9300NChristensen Hans · Enterprise, UTN9300XEdwards Karen Marie · Mcminnville, ORN93010Davis Russell C · Odessa, TXN93018Joy Austin J Jr · Anchorage, AKN9301BGimli Son LLC · Fort Lauderdale, FLN9301ERyan Aircraft Holding LLC · Orlando, FLN9301XShaunkoe LLC · Merrill, ORN93020Red Leasing LLC · Juneau, AKN93022Red Leasing LLC · Juneau, AKN93023Ward Air Inc · Juneau, AKN93024Ward Air Inc · Juneau, AKN93025Kiesel Edward K · Juneau, AKN93027Indy Air LLC · Blaine, MNN93030Cathey Wacey D · Polson, MTN93033Kaval John P Jr · Duxbury, MAN93035Des Aircraft LLC · Marianna, ARN93039Dorris Michael R · Mccall, ID
Back to AD 79-10-14 R1