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.
N621AKelsey John · Casa Grande, AZN621APEast Moriches Aerial Ads Ltd · Ridge, NYN621BKMy170b LLC · Everett, WAN621CLN621cl LLC · Overland Park, KSN621DCResource Extension LLC · Jupiter, FLN621GTFox Edward Philip Jr · New Market, ALN621MAAnderson Keith R · Norwood, MAN621MRElliott Michael R · Friendswood, TXN621PMAtp Aircraft 1 LLC · Wilmington, DEN621PWSkyten Flying Club Inc · Orefield, PAN621SJAirmax Internet LLC · Troutman, NCN621TCsa Aircraft Leasing LLC · Salt Lake City, UTN621WHerzog Daniel L · Clinton, MIN62209Christiansen Aviation LLC · Wilmington, DEN6220EStoudt Kristen D · Derby, KSN6220FHeberle David B · Castroville, TXN6220GDuncan Paul J · Bartlett, TNN6220KKasden Louis Jr · San Diego, CAN6220NSchmidt Paul D · Derby, KSN6220TStorey Erik A · Fillmore, CAN62217Wieken Peter J · Mount Joy, PAN62218Above The Clouds Aviation LLC · Middletown, DEN6221AFlight Level Avionics & Maintenance Services LLC · Milton, FLN6221EAllgeier David G Jr · Taylorsville, KYN6221KWilson Steven J · Elkton, KYN6222AAir Charter · Ottawa, ILN6222EAlexander Tom · Alamogordo, NMN6222FPhotos Unlimited · Rancho Cordova, CAN6222GCosgrove Coleman · Juneau, AKN6222RBarge And Associates Inc · Houston, TXN6223BSpirek Aaron M · Henderson, NVN6223GGulasy Teresa L · Tulsa, OKN6223RBroadwell Eric · Woodstock, GAN6223SKlingele Beth A · Wapato, WAN6223VAxis Aviation LLC · Bloomingdale, GAN62244Christiansen Aviation LLC · Wilmington, DEN62245Gabrieles Wings LLC · Oldwick, NJN6224AAviation Of North Florida LLC · Jacksonville, FLN6224FMerrill James · Bigfork, MTN6225AMilpower Inc · Nampa, IDN6225QElkinton Dusty Lee · Moundville, MON6225RHartman Michael F · Montclair, CAN6225TMohnacky Robert A · Roscoe, ILN6226Lewis Jay C · Spanaway, WAN62266Skylens LLC · Hammond, LAN6226ADaggett Aviation Inc · Daggett, CAN6226FLone Creek Ranch LLC · Williston, NDN6226KBoard Of Trustees Of Western Michigan University · Battle Creek, MIN6226RHamman Baron L · Dallas, TXN6227AAllur Air LLC · Minnetrista, MN
Back to AD 79-10-14 R1