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.
N64153Davies Thomas V · Chula Vista, CAN64154Jw Skyhawk LLC · Austin, TXN64155Lowcountry Flight LLC · Johns Island, SCN64157Christensen Jeffrey S · Wisconsin Rapids, WIN64159Flying 14 LLC · Spokane, WAN6415APekkala John W · Palmer, AKN6415FDewitte Jon James · Bishop, GAN6415RAlpine Aviation Of Fayetteville Inc · Prairie Grove, ARN6415SJohnson Edward A · Columbia, SCN6415TEnglish Gary M · Clermont, FLN6415VPeter Prince Aviation Center LLC · Milton, FLN6415XPogany Steve C · Chugiak, AKN64160Glide Slope LLC · East Hampton, NYN64161Aom Aircraft LLC · Orlando, FLN64162Mccormick Philip D · Mount Pleasant, IAN64163Good Airplanes LLC · Oshkosh, WIN64165Weaver Lynwood J Jr · Raleigh, NCN64167Registered aircraftN6416AJanak Jeffrey · Corpus Christi, TXN6416GRolin Brian · Mc David, FLN6416KShreveport Aviation Services LLC · Shreveport, LAN6416SCerny Mark V · Canyon City, ORN6416TMitchell Paula E · Norman, OKN64173Training Planes LLC · Tampa, FLN64174Sen Air Inc · Mckeesport, PAN6417ALevasseur Peter W · Plymouth, MEN6417ESharpley David Jr · Pittsboro, INN6417FAdkins Ian B · Dahlonega, GAN6417JChapman Michael K · North Salt Lake, UTN6417KVaro-Real Investments Inc · Visalia, CAN6417NTaylor Michael Norman · Chino Hills, CAN6417TBazeley Paul J · Aurora, ORN64180Spanaflight LLC · Puyallup, WAN64181Christiansen Aviation LLC · Wilmington, DEN64183Chiappe Glenn R · Lago Vista, TXN64184Arlington Flight Services Inc · Arlington, WAN64186Paraloft LLC · Mims, FLN6418DAirways Aviation Inc · Grand Rapids, MNN6418ELima-001 LLC · Muscatine, IAN6418XCoffman David W · Wilbur, WAN64191Flycarolina LLC · Concord, NCN64192Skyhawk Transport LLC · Hazel Green, ALN64198Randy Goering Inc · Bend, ORN64199Mutschler George Robert Jr · Bayfield, CON6419BMarshall Timothy M Trustee · Tucson, AZN6419TBaich Michael V · Coleraine, MNN6419VUrbana Aircraft LLC · Urbana, MDN6419XPernat Frank J Trustee · Chaska, MNN641ABDaccarett Marcos · Boise, IDN641DACavu Aviation LLC · Lake Geneva, WI
Back to AD 79-10-14 R1