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.
N45132Jamesweathers Robi J · Blaine, MNN4513BBishop Robert W · Celina, TXN4513CSlowpoke Air LLC · Palm Harbor, FLN45143Fly Sky Ads LLC · Manalapan, NJN45156Flight Training Solutions LLC · Longwood, FLN4515BWestern Parachute Sales Inc · Eagle Creek, ORN45166Jet Life LLC · Coconut Creek, FLN45169Carlisle Elizabeth L · Mohnton, PAN4516CStahlman Michael J · Portland, ORN4516USteelman Aviation LLC · Montague, CAN45170Smits Joel R · Crete, ILN4517B4517b Holding Group LLC · Moses Lake, WAN4517CHainline Thomas D · Sumter, SCN4517FAeropod Inc · Aurora, CON45188Arias Armando D · Santa Cruz, CAN4518CLongden Earl W · Spirit Lake, IDN45190Violette Colin E · Rough And Ready, CAN45193Bostwick James · Melrose, NMN45198Ebe Aviation LLC · Urbandale, IAN451BA1928 LLC · Salmon, IDN451CPCivil Air Patrol · Maxwell Afb, ALN451NACooke J C Jr · Crystal Springs, MSN451SWAircraft & Aviation Professionals LLC · Coldwater, MIN45203November 45203 LLC · Waterbury Center, VTN4520FRegistered aircraftN4521BWitthaus James K Jr · Anchorage, AKN4521URodriguez Sergio · Rancho Cucamonga, CAN4522CEvans Michael R · Nome, AKN45230Zutter Regan James · Hooper, UTN45235Grimes James R · Carlton, GAN45237Defrees Brooks H · Boulder, CON4523CShelton Agri Services Inc · Hereford, TXN45243Keas Kirby Clay · Lakeway, TXN45245Rimar Dale S · Boca Raton, FLN45246Carlsen Brent R · Rochester, MNN45247Airgo Inc · Centralia, ILN45248Lewis Steven A · Mesa, AZN4524CMcateer Kristina · East Greenwich, RIN4524UJennett Chris · Hudson, FLN45250Thiele Klaus U · San Diego, CAN45256Albertson James M · Westville, FLN45262Wyoming Aviation Association Inc · Cheyenne, WYN45263Ruder Bonita E · Maple Park, ILN4526CWhitson Ryan L · Audubon, NJN4526UDrewelow Kevin R · Topeka, KSN45270Lessley Gavin W · Carrollton, MSN45274Robinson Charles F · Portage, MIFirst renewal noticeN45277Fritz Kurt C · Montoursville, PAN4527BKrogman Aerial Spraying Inc · Lake Lillian, MNN4527UToth Karl A · Fair Oaks, CA
Back to AD 79-10-14 R1