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.
N4552CMckinney Lodging Management LLC · Trout Lake, WAN45530Young Thomas E Jr · Alton, MON4553SMinion Air Inc · John Day, ORN4553UCoyle Jonathan D · Franktown, CON45541Zxtair LLC · Mankato, MNFirst renewal noticeN45542Baldridge Steven J · Edmonds, WAN4554FFejes Jacob J · Watertown, NYN4555CVan Roo Jon D · Hartland, WIN45560Johnson Adam · Denton, TXN45563Tremer Jesse · Kathleen, GAN45566Watts Charles B IV · Pace, FLN45570San Mateo Flying Club Inc · Palo Alto, CAN4557FKincaid Jonathan A · Frankfort, MEN4557UCrum Thomas A · Loyal, OKN45582Burch Jacqueline L · Aguanga, CAN45586Rak Aviation LLC · Everett, WAN45588Dahlonega Mountain Flyers Inc · Dahlonega, GAN4558BDe Ley Taylor · Yorba Linda, CAN4558CFarrell Raymond E · Monument, CON4558FN4558f LLC · Columbus, OHN4559UBoyd Jeffrey S · Hutsonville, ILN455AFGlacier Bay Aviation LLC · Fayetteville, GAN455AKBarr Scott A · Barrow, AKN455CPCivil Air Patrol · Maxwell Afb, ALN455EDTurner James Glenn · Naples, FLN455EPDove Aviation 455ep LLC · Stuart, FLN455HSSagnieres Hubert · Newport, VTN455WCHayes William F · Perrysburg, OHN45601Three Four Juliet LLC · Orange, CAN45613Devanani Vishnu D · Orlando, FLN45614Gard Lionel V III · Camp Wood, TXN45617Schumaker Grant E · Wichita, KSN4561VOrca Wealth Management LLC · New Port Richey, FLN45623Prosperous Holdings LLC · Gainesville, GAN45626Creamer James P · Lakeland, FLN4562FMcdaniel Dean K · Queen Creek, AZN45632Marble Jere D · Dayton, NVN45636Carolina Tripacers LLC · Summerville, SCN4563BLarose Gary R · Anchorage, AKN4563CBrown Peter D · Anchorage, AKN4563UBailey Wesley S · Bulverde, TXN4563WE&V Air LLC · Chatsworth, GAN45649Cygan Fred P · Hudson, MAN4564CMountain Todd Lee · Byron, MIN45659Mcallister Christopher E · Phoenix, AZN45662Turnberry Air LLC · Oviedo, FLN45663Williams Kaylee A · Grapevine, TXN4566BWagnon Bertram L · Anchorage, AKN4566UGruver Norval T · Bartlesville, OKN45673Theimer Ryan D · West Bend, WI
Back to AD 79-10-14 R1