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.
N7577XBlusky Aviation LLC · Palmyra, INN75786Bienvenu Reuben S · Lafayette, LAN75788Hawk Air LLC · Parma, OHN7578GThree Little Birds Inv LLC · Nashville, TNN7578MSjeversen Michael D · Mora, MNN7578SFly Cessna 182q N7578s LLC · Kalispell, MTN7578VWillis Daniel M · Shelbyville, TNN7578XHamilton Randel L · Quitaque, TXN75790Kempton Larry G · Grand Junction, CON75791D L S Aviation Services Inc · Wilmington, DEN75793Miami Valley Career Technology Center · Clayton, OHN75794Appleton Scott · Cunningham, TNFirst renewal noticeN75795Harrison Mark A · Corpus Christi, TXN75797Eralet Inc · Middletown, DEN75799Ocean Breeze Aviation Inc · Hollywood, FLN7579VSteenson James H Jr · Hudson, NHN757DJPanepinto Lane P · Lafitte, LAN757LELake Elmo Aero LLC · Lake Elmo, MNN757MK101 Flight LLC · Waterford, MIN757RShepard Peter M · Wasilla, AKN757RJCenter Brian · Garwood, TXN757WKKuersteiner William C · Panacea, FLN75801Hartland Aviation LLC · New Smyrna Beach, FLN75803Kuntz Donald Alan · Whitefish, MTN75805Roney Howard D · Salem, ORN75806Jones Bros Amc Jeep Inc · Harrison, ARN75807Pearl River Community College · Poplarville, MSN75809C & S Flyers LLC · Grand Lake, LAN7580NSparling George · Grand Prairie, TXN7580VBinzel Charles P · Bristol, WIN7580XSorgen Michael A · Corning, NYN75816Lns Aviation LLC · Chandler, AZN7581GManasco Inc · Tucson, AZN7581SFoxaire LLC · Austin, MNN7581UOse Leroy B · Thief River Falls, MNN7581VJacoby Billy L · The Villages, FLN75820Zoviv Michael · Hollywood, FLN75822International Air Services Inc Trustee · Carson City, NVN75823Wings Over Texas Holdings LLC · Denton, TXN75824Williams John S · Fort Walton Beach, FLN75825Patrick Ronald D · Locust Grove, GAFirst renewal noticeN75829Hofmann LLC · Blauvelt, NYN7582GCapps Christopher T · Anchorage, AKN7582HStiltner Sean · Piketon, OHN7582KErb Jason E · Barron, WIN7582TJones Todd R · Ozona, TXN7582VKlebanoff Mark · Worthington, OHN7582XSemchenko Norval K · Max, NDN75831Mccall Freddie W · Century, FLN75833Blees James E · Anchorage, AK
Back to AD 79-10-14 R1