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.
N7301THolte Martin W · Burnsville, MNN73020Ajf Enterprises LLC · Des Moines, IAN73028Halley Craig H · Lanai City, HIN7302ASkywagon Aero LLC · Wilmington, DEN7302GSmith Neil W · Rincon, GAN7302MKoenig Donald J · Las Animas, CON7302NClark Frank C · Pinckney, MIN7302QDuckworth Bill J · Epps, LAN7302TSchaff James F · Prescott, AZN7302XGlover Thomas · Marana, AZN73036Johnson Deborah K · Fairbanks, AKN7303ALogajan James M · Rapid City, SDN7303GGolden Greg J · Thurman, IAN7303MHerbert Robert Leo · Ammon, IDN7303NJordan James D · Paradise, TXN7303XBosch Kent D · Montevideo, MNN73040Goulding Brian K · Roswell, GAN73041Max Air Aviation LLC · Carrollton, GAN73043Six Ten Ventures LLC · Cedar Hill, TXN73047Spernak Airways Inc · Anchorage, AKFirst renewal noticeN7304GChapman David C · Summersville, WVN7304NCoastal Aviation Export LLC · Wilmington, DEN73054Blue Wings LLC · Spokane, WAN7305AK&M Aviation LLC · West Liberty, KYN7305QWolding Mylo D · New Town, NDN7305SJones Keith J · Tucson, AZN7305URyan Air Inc · Anchorage, AKN73063Oregon State Flying Club · Corvallis, ORN73064Whitelam Bruce R · Sacramento, CAN73067Grant Aviation Inc · Anchorage, AKN73068Christensen Gary D · Alliance, NEFirst renewal noticeN73069Eagle Sky Patrol Inc · Deadwood, SDN7306AFloyd Ckyler Don · Bowman, NDN7306EG & M Aircraft Inc · Wheat Ridge, CON7306QOllee Air LLC · Smithfield, UTN7306SBennett Aviation LLC · New York, NYN7306TFaull Ron W · Sandpoint, IDN7307ACook Raymond L · Clarksville, TNN7307NLow Michael E · Hurricane, UTN7307QN7307q LLC · Wickenburg, AZN7307SDunlap Michael L · Haymarket, VAN73088Kalivas William Nick · Dallas, TXN7308GOrlandi Properties LLC · Blairstown, NJN7308TBerg Weston L · Stanton, NDN7308XEsmond Emmett W · Seattle, WAN73091Rudder33 LLC · Grantham, NHN73093Yngsdal Dale A · Lino Lakes, MNN7309MDunn Louis Jr · Mooresville, NCN7309NMartyn Michael L · Inyokern, CAFirst renewal noticeN7309QWayne Kenneth B · Sonoma, CA
Back to AD 79-10-14 R1