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.
N53057Endsley Gregory C · Sterling, AKN53059Smith Sidney R Trustee · Rllng Hls Est, CAN5305BHamlin Curtis G · North Pole, AKN5305CRegistered aircraftN5305KJ M F And Associates Inc · Alexandria, VAN5305NBennett Brian · Horseheads, NYN5305RWoodman Larry · Nottingham, NHN5305SJohnson Brent C · Appleton, MNN5305TMccall Freddie W · Brewton, ALN5305VAmerican Academy Of Aeronautics Inc · Stanford, CAN53061Flying Ducks Aviation LLC · Newport, ORN53065Cherry Hill Aviation LLC · Freetown, INN53068Legends Air Center LLC · Bentonville, ARN53069Northwoods Air LLC · Orono, MEN5306CSo Cal Leasing LLC · El Cajon, CAN5306EN5306e LLC · Ashburn, VAN5306KMills Bradley W · Wichita Falls, TXN5306RSheldon Scott H · Cohasset, MAN5306UAircraft Solutions Group LLC · Englewood, CON53070Wnc Aviation LLC · Arden, NCN53073Zahnow Todd · Raub, NDN53076Rjr Aviation LLC · Ridge, NYN53077Megasky Holdings LLC · Charleston, SCN5307BHunter Warren M · Rainelle, WVN5307QSkyway Leasing Inc · Lakeland, FLN5307RFabian Brian L · Corcoran, MNN53080Isaacs Christopher W · Advance, NCN53083Clearwater Potlatch Timber Protect · Orofino, IDN53087Colorado North Western Community College · Rangely, CON53088Sangal Shiddhartha · Annandale, NJN5308QBig Sky Leasing LLC · Boise, IDN5308TAvventura LLC · San Marcos, CAFirst renewal noticeN53092Reilly Patrick M · Anchorage, AKN5309BKadlubowski Michael J · Colorado Springs, CON5309DPotter John · Payson, UTN5309FMedary Aviation LLC · Brookings, SDN5309JRegistered aircraftRegistration pending, pending cancellationN5309QSauvageau Daniel W · Roseville, CAN5309SEnd Poverty Now Inc · Maumee, OHN5309VFlight Training Aircraft LLC · Wilmington, DEN530AUWateractive43 LLC · Auburn, CAN530ERZima Aviation LLC · Huntington, CAN530MBBrill Nathan · Austin, TXN530MTAcron Aviation Academy Inc · Sanford, FLN530NDAerosim Academy Inc · Sanford, FLN530PSSpartan Education LLC · Tulsa, OKN530RCLoizides Louis N · Safety Harbor, FLN530SCFoxtrot Aviation LLC · Oregon City, ORN530TC530tc LLC · Nashville, TNN530WBDmb Aircraft Inc · Wilmington, DE
Back to AD 79-10-14 R1