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.
N616JHHarcatco LLC · Corsicana, TXN616MCFletcher Flying LLC · Russellville, ARN616PJLarson Paul S · San Carlos, CAN616SFAmelia Reid Aviation LLC · San Jose, CAN616SKSuperior Flying Services LLC · Superior, WIN616WERodriguez Norberto R · Inwood, NYN61700Torres Ramon L · Mulberry, FLN61701Jls Aviation LLC DBA · Fredericksburg, VAN61703Beising Steven · Las Vegas, NVN61704Glick Mervin L · Stanardsville, VAN61705White Robert Tyler · Pleasanton, CAN61707Spartan National Holdings LLC · Missoula, MTN61709Caldwell Clifton · Sterling City, TXN6170BEnglish Stanley P · Anchorage, AKN6170FWilkins Raymond E · Osceola, IAN6170NGarmin210 LLC · Willard, MON6170RBrown Michael R · Huntsville, ALN6170THerman David B · Seattle, WAN61710Bob Hoover Academy Inc · Salinas, CAN61713Miller Melanie L · Spanaway, WAN61718Ortman Bernard R · Bozeman, MTN6171EAvequities Inc · Dallas, TXN6171FDohrenwend Mark G · Owensboro, KYN6171GMission Flight Academy · Yucaipa, CAN61727Mays Gloria J · College Station, TXN61728Henderson James Ross · Garden Prairie, ILN6172DBlue Spruce Aviation LLC · Fairview Park, OHN6172EKatz Braunschweig Daniel A · Staten Island, NYN6172GTappan Scott M · Port Saint Lucie, FLN6172TMckinney Peggy A · Hamersville, OHN61733Pan Air Flying Club Inc · Miami, FLN61737Executive Flight Institute LLC · Murrieta, CAN61738Finn Development LLC · Kaysville, UTN61739Southern Aero LLC · Homestead, FLN6173FLesondank Stephen M · Bellvue, CON6173QKinder Mark Edward · Bozeman, MTN6173RBeyer Livestock Auction LLC · Clovis, NMN6173TGreat Pilots LLC · Rocklin, CAN61742Fox James R · Saint Paul, MNN61743Carruth John T · Danvers, MNN61747Lakes Aircraft LLC · Little Canada, MNN61748Zapata Raymond E · Cabo Rojo, PRN61749Kellogg Wade A · Chelsea, MIN6174BN6174b LLC · Nokomis, FLN6174ECano Michael J · Vallecito, CAN6174GMosley Gabriel T · Oak Hills, CAN6174RLaurel Highlands Aeronautical Academy · Latrobe, PAN61752Lee Robert Eric · Charleston, WVN61755K E F Enterprises · Plymouth, MAN61757Smith Bradford W · Duluth, MN
Back to AD 79-10-14 R1