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.
N5072AGibbs James P · Boerne, TXN5072GRuffaire LLC · Midland, TXN5072HRiebeling Eric Herbert · Reno, NVN5072UStopka Alexis L · Belgrade, MTFirst renewal noticeN50732Lil 150 LLC · Sauk Rapids, MNN50734Dillman Kurt A · Victor, NYN5073HElite Planes LLC · Menifee, CAN5073NPavco Inc · Gig Harbor, WAN5073RMckenna Brothers Aircraft LLC · Anchorage, AKN50745Caicedo David · Villa Rica, GAN50747N50747 LLC · Great Falls, MTN50748Freeman Teresa L · Kinston, OHN50749Blackwater Aviation LLC · Douglas, GAN5074DAhumada George · Palmer, AKN5074EKauffman Stephen E · Anchorage, AKN50750Christensen William A · Dallas, TXN50759Thode Leonard E · Michigan City, INN50762Skyhawk Group · Kent, WAN50766Sheets Laura J · Follett, TXN50769Miller Justin · Boaz, ALN5076EJensen Adam G · Anchorage, AKN5076NJb Aviation Flight School Inc · Wonder Lake, ILN50770Schlegel Mark W · Waterford, MIN50771Flying Mermaid LLC · Aiea, HIN50772Donnelly Jennifer A · Hackettstown, NJN50774White T William · Londonderry, NHN50777Morlan Scott A · Indianola, IAN5077APut Willem Albert · Birmingham, ALN5077DPrentiss Zachary Callan · Grand Junction, CON5077EWest Elk Air LLC · Gunnison, CON5077RHawkins Transportation LLC · Anchorage, AKN50781Beard Michael E · Udall, KSN5078ASmith Sidney R · Rllng Hls Est, CAN5078RBlue Goose Aviation Inc · Polson, MTN50790Taylor Terry D · Orange Park, FLN50793Matter In Motion Inc · Fox River Grove, ILN50799Jungren Brett F · Elmwood, NEN507DGLynn John Earl Jr · Anchorage, AKN507DMChristiansen Aviation LLC · Wilmington, DEN507DROrtega Aviation Services LLC · Wichita, KSN507EREmbry-Riddle Aeronautical University Inc · Prescott, AZN507LAColumbia Leasing LLC · Hillsboro, ORN507PHocker Matthew Tutt · LondonN507SDKnapp Jason D · Schenevus, NYN50805Dale Aero LLC · Eloy, AZN5080ACoughlan Sally G · Bigfork, MTN5080DJohnson Kenneth J · Red Bluff, CAN5080EAdams Kenneth C · Neosho, WIN5080YOptic Air LLC · Maurice, IAN50813Record John W · Apison, TN
Back to AD 79-10-14 R1