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.
N7806LRegistered aircraftN7806SAeroquest LLC · Plano, TXN7806ZRobinson Jordan P · Lexington, NCN78076Clinton Aeroclub · Clinton, IAN78078International Air Services Inc Trustee · Carson City, NVN7807ERegistered aircraftAssigned, pending cancellationN7807FFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeN7807GLake Of The Woods Aviation LLC · Baudette, MNN7807KSutton Aircraft Salvage LLC · Palmer, AKN7807XFarwell Joseph W · Holmen, WIN7807ZSmokovitz Joseph M · Tecumseh, MIN78086Drake Ronald N · Helena, MTN7808ESauls Billy J · Hollow Rock, TNN7808KRegistration Pending · Fort Collins, CORegistration pendingN7808TMckay H Samuel · Barnwell, SCN78091Stumberg Richard Kirk · Pottsboro, TXN78092Sale Reported · Prescott Valley, AZSale reported, pending cancellationN78095Leuer James A · Encinitas, CAN78098Fahrenkamp Russell E · Parker, AZN7809EHavelka Justin R · Mcgregor, TXN7809GHodge Aviation LLC · Monroe, LAN7809KAdamson Bradley R · Cody, NEN7809UHigh Planes Aviation LLC · Waseca, MNFirst renewal noticeN780ALas Margaritas Aviation LLC · Qulin, MON780BGMaw Enterprises USA LLC · Hudson, FLN780BWBridgewater State University · North Dartmouth, MAN780CPCivil Air Patrol · Maxwell Afb, ALN780EREmbry-Riddle Aeronautical University Inc · Prescott, AZN780ESFlying Pineapple LLC · Naples, FLN780HN780h LLC · Angola, INN780JAPhoenix East Aviation LLC · Daytona Beach, FLN7810Danger Zone Aviation LLC · Ham Lake, MNN78102Sonoma County Land Company Inc · Santa Rosa, CAN7810ABlack Diamond Soaring Inc · Oley, PAN7810KBecker Michael A · La Grande, ORN7810URasch Hellmut G · Tomball, TXN7810XCoats Benjamin F II · Ducktown, TNN78112Botnick Eric L · Luling, LAN78115Cm3 LLC · North Las Vegas, NVN7811EWinkler William R III · Boone, NCN7811THoke Cylus G · Culver, ORN7811XMach 3 LLC · Enid, OKN7811ZTeske Robert E · Kalamazoo, MIN78123Rrr3 LLC · Midway, FLN78124Barrow James L · Elizabethtown, KYN78126Orme Jason R · Red Oak, IAN7812TCurzon John R · Brookings, ORN7812UPs Aviation Inc · Granada, MNN7812ZAbbe Thomas E · Wasilla, AKN78130Garoutte Kirk E · Anchorage, AK
Back to AD 79-10-14 R1