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.
N831AFAmeriflyers Of Texas Inc · Addison, TXN831BRAir Future Airways Corp · Miami, FLN831CBSummersell Steven K · Pensacola, FLN831DC831 Aviators LLC · Monterey, CAN831DTR & R Plane LLC · Lewiston, IDN831EREmbry Riddle Aeronautical University · Daytona Beach, FLN831JNErlanger Joshua · Jupiter, FLN831KXRkm Leasing LLC · Greenwich, CTN831LLState Of Illinois · Springfield, ILN831MAState Of Wisconsin · Madison, WIN831NCCole Curtis J · Loveland, CON831PRThomas Bruce A · Mount Juliet, TNN831PZHildebrant Thomas M · Ringling, OKN831RRFresh Farms Inc · King City, CAN831SMSkowhegan Leasing Inc · Skowhegan, MEN831VZMelbourne Flight Training LLC · Melbourne, FLN8320MBoyce Dale M · Southport, NCN8320TMoeller Channing T · Huntsville, ALN8320XHagovsky Thomas C · Attica, INN8320ZDeel John Tate · Hico, WVN8321BSkyhawk18 LLC · Opa Locka, FLN8321GSilveria Clifford J · Humble, TXN8321UBoss Bradley J · Clarksville, TNN8321ZOverholt Air LLC · Wilmington, DEN8322AFlack James R Trustee · Loudonville, OHN8322JMiller Patrick · Riverside, CAN8322UBurkett Kevin H · Portland, TXN8323EBrod Norman B Trustee · Napa, CAN8323FDavis William · Texarkana, TXN8323GRusso Dobye G · Clinton, OKN8323JKc Eagles Soaring Club · Gardner, KSN8323MBean Danny O · Mulkeytown, ILN8323UFortman Steven W · Minneapolis, MNN8323XHumpage Jason H · Eugene, ORN8324BVitt Steven · Lecanto, FLN8324EGc Aviation Services-1 LLC · Miamisburg, OHN8324GDexter Brady R · Chambers, NEN8324MKnox John D · Broken Arrow, OKN8324SWhat Next? LLC · Fallon, NVN8324XJohnson Scott A · Missoula, MTN8325ASutton Aircraft Salvage LLC · Palmer, AKN8325BDeckard Leroy Jr · Waller, TXN8325UCross Dustin · Tonto Basin, AZN8326ARacoon Aviation LLC · San Antonio, TXN8326UHill John R · Seattle, WAN8326XFlores Thomas E · Balch Springs, TXN8327JSaunders Grant J · Sebring, FLN8327MArch Frederick W Jr · Lake Placid, FLN8327TMatson Donald Jr · Lake Stevens, WAN8327XTwo Seven Xray LLC · Paradise Valley, AZ
Back to AD 79-10-14 R1