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.
N7971UHallstrom Curtis R · Barnesville, OHN7971VDossenback Kelly · Folsom, CAN7972GMinot Aero Center · Minot, NDN7972VDionisio John · West Covina, CAN7972ZResley James B · Sierra Blanca, TXN7973EDunham Matthew J · Duarte, CAN7973ULewis Mark A · Ozark, ALN7973VRickman Allen K · Absarokee, MTN7974BBraymer Jay K · Boerne, TXN7974EJstream Lc · Sheridan, WYN7974FMerriam Hugh M · San Leandro, CAN7974TByers Theresa L · Freedom, CAN7974XKalamazoo Flight Instruction LLC · Kalamazoo, MIN7975UStrickland Paul A · Goleta, CAN7975XGessinger Gregory S · Nappanee, INN7975ZLansing Community College · Mason, MIN7977UWittenburg Brandon L · Vancouver, WAN7978ESalyer Spencer · Modesto, CAN7978UNorthwoods Gateway Aviation LLC · Antigo, WIN7978VSlinger LLC · Laramie, WYN7978ZFlint Harry L · Falls City, NEN7979EAglar Daniel P · Agate, CON7979FAtkins Adam T · Fort Mill, SCN7979TIvy James H III · Seligman, AZN7979XKnutson Wayne R · Thompson, NDN7979ZLindenschmidt Eric J · Mount Vernon, INN797CJSteim Joseph M · Shirley, MAN797DJN797dj LLC · Fayetteville, GAN797DTEngelskirger Karl D · Valley City, OHN797FAChristiansen Aviation LLC · Wilmington, DEN797LCMeziere Richard A Jr · Boise, IDN797RJSeven 4 Zulu LLC · San Diego, CAN797SPSundowners Inc · Fort Myers, FLN797TMMilliren Karl · Thomasville, NCN79805Wings Over Texas Holdings LLC · Denton, TXN7980BMikesell Luke A · Fairland, OKN7980EEhrhardt Eric · Wauconda, ILN7980ZMartin Tyler · Rexburg, IDN7981TAshmore Rod L · Bonita Springs, FLN7981USkyhawk Aviation LLC · Midland, MIN7982BUlmer Brian K · Huachuca City, AZN7982EBodin Logan · Lake Charles, LAN7982FPlane Sane C1 LLC · Cary, NCN7982ULastowski Jeffrey A · Mooresville, INN7983FKoons Brian D · Canton, OHN7983GLuse David C · Newalla, OKN7983XLine Ricky L · Liberty Hill, TXN7984BYoung Kenneth R · Waco, TXN7984GChampion Air LLC · Louisville, KYN7984UButter Kendall L · Gatesville, TX
Back to AD 79-10-14 R1