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.
N59146Universal Charter Service Inc · Auburn, CAN5914BStrong Brian DBA · Southport, NCN5914JFreedom One Inc · San Jose, CAN5914RWaldrop Charles Trustee · Oklahoma City, OKN59150Jp Aero Holdings Inc · Carson City, NVN5915AMyers Glen L · Grassy Butte, NDN5915BTaylor Scott G · Draper, UTN5915FJeffries Phillip L · Belington, WVN59164Marine Electrical & Refrigeration Of Kodiak LLC · Kodiak, AKN5916EBetz Albert N Jr · Lewiston, IDN5916FTlc Flying Inc · Colfax, WAN5916JUnited States Air Force - Owner · Eglin Afb, FLN59173Vogelgesang Randy · Gardnerville, NVN59175Brown Charles A · Boise, IDN5917BHauser Nathan S · Newark, DEN5917EConnor Liam Maxwell · South Range, WIN5917RParcell Evelyn Cassandra · Norfolk, VAN59180Kennedy Jared W · Cordova, AKN59181Meader Luke C · Marfa, TXN59182Abbott James H · Gallatin, TNN5918JStansfield Carl B · Springdale, UTN5918T2400 Rickenbacker LLC · Auburn, CAN5919AFederico Gilbert · Litchfield Park, AZN5919BBell Ian E · Rapid City, SDN5919EBeaty David L · Mesa, AZN5919JFiles Richard W · Yuma, AZN591CPCivil Air Patrol · Maxwell Afb, ALN591NCPotto Aviation Inc · Wilmington, DEN5920A20 Awesome LLC · Albuquerque, NMN5920RAmerican Eagle Aviation LLC · Flushing, MIN5920TLowe David M · Sacramento, KYN59210Safe Pilots Group LLC · Nyack, NYN5922AArmiger Scott L · Holly Springs, NCN5922BLitton John C · Quartz Hill, CAN5922EAerial Scouting Solutions LLC · Sioux Center, IAN5922JMerlin Iron Works LLC · Westwood, KSN5922THamilton David A · Piedmont, OHN59237Boland Matthew S · Anchorage, AKN5923ARowlett Glen R · Brookshire, TXN5923BWilson Phillip K · Waukesha, WIN59240Banegas Jose Carlos Zankiz · Flint, TXN5924BZarinnia Anthony · Chelsea, MIN5924ENowlin Edwin H III · Oakboro, NCN5924GParsons Roderick L · Ripley, WVN59258Energy Roofing Technology Se LLC · Lake City, FLN5925TGrizzle Kenneth A · Jerseyville, ILN5926ERegistration Pending · Marble Falls, TXRegistration pendingN5926GMirandan5926g LLC · Napanoch, NYN5926JVintage Aviation LLC · Billings, MTN5926TPalyash Neil J · Wichita, KS
Back to AD 79-10-14 R1