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.
N5374KApex Aircraft Leasing LLC · Anchorage, AKN53759Pacific Lease · Elk Grove, CAN5375DRamstad Trygg J · Anchorage, AKN5375JDaviss Joseph A · Sylacauga, ALN5375RArctic Flying Club · Fairbanks, AKN5376CDynamic Aerospace Inc · Framingham, MAN5376HPires Fernando L · Hilmar, CAN5376JTss Aviation LLC · Conyers, GAN5376NCowgill John David · Studio City, CAN5377CAnderson Robert C · Zanesfield, OHN5377DDesantis Anthony · Memphis, TNN5377TAllen James W · Lakewood Ranch, FLN5377VShoemake Stephen Sidney · Pine Mountain, GAN5378DMustang Sally Aviation LLC · Camden, SCN5378ENuxoll Randy G · Eagle, IDN5378KUnique Educational Experiences Inc · Signal Hill, CAN5378PBlue Skies Today LLC · Eagan, MNN5378RGittlein Paul A · Wasilla, AKN53794Rick Aviation Inc · Newport News, VAN53797Christiansen Aviation LLC · Wilmington, DEN5379ABrechtelsbauer Paul · Farmville, NCN5379BBtp Inc · Missoula, MTN5379QSky Limit Services LLC · Miami, FLN5379TBerry Kevin R · Bowie, TXN537EREmbry-Riddle Aeronautical University Inc · Prescott, AZN537HFSilver Express Co · Miami, FLN537HPBarr Air Patrol LLC · Mesquite, TXN537KSKent State University · Stow, OHN537NDSpartan Education LLC · Tulsa, OKN537SAMills Michael R · Saratoga Springs, NYN537SP5280 Flying Club LLC · Castle Pines, CON537TTDudley Lee Brent · Passadumkeag, MEN537WMWeaver John D · Susanville, CAN5380BGroll Michael · Logan, UTN5380CCoggins Josh · Bonney Lake, WAN5380NRackley Harvey R Jr · Liberal, KSN5380QFoy Timothy D · Malvern, PAN5380SRoss Rexford E · Phoenix, AZN5380TEdwards Air LLC · Raleigh, NCN5381CBergman James H · Buckley, WAN5381DSchallip Robert G Jr · Barbeau, MIN5381EMiller Christopher D · Boulder, CON5381NBrentco Aerial Patrol Inc · Canton, OHN5381QAirgo Inc · Centralia, ILN53822American Patrols Inc · Midland, TXN5382BBook Paul A · Richvale, CAN5382DEagles Flying Club · Saint Charles, MON5382QMiller Charles L · Mooresville, NCN5383ASummers Timothy P · Rincon, GAN5383CJenkins David A · Gainesville, FL
Back to AD 79-10-14 R1