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.
N6602HOver The Mountain Aviation LLC · Calera, ALN66033Schwarz Wesley E · Ovalo, TXN66034Shaffer Mark N · Ocala, FLN66038Landrum Erik G · Austin, TXN6603AWise Phillip L · Harris, MON6603ERequa Kerry E · Twin Falls, IDN6603FAres Andrey · Fort Lauderdale, FLN6603SColonial Air Inc · New Bedford, MAN6603UN6603u LLC · Albuquerque, NMN66040Sierra Auto Recycling Inc · Ridgecrest, CAN66041Wof Investments LLC · Dover, DEN66042Hudson Steven E · Junction City, KSN66046Palm Beach Flight Training Corp · Lantana, FLN66047Shiles Darrell J · Baltimore, MDN66049Aerosync LLC · Miami, FLN6604AFlight Club LLC · Dover, DEN6604EFlyn High Aviation LLC · Boynton Beach, FLN6604TGrimes Matthew K · Norman, OKN66054Wooten Jeffrey B · Rock Hill, SCN66055Tas Aviation Aircraft Sales LLC · Defiance, OHN6605AKehoe Troy D · Bridgeport, TXN6605DAlameda Aero Club · Alameda, CAN6605ESmith Daniel · Kingsland, TXN66063Taylor Jonathon K · Carlsbad, CAN66064Radford Lawrence · Scottsdale, AZN66068Phoenix East Aviation LLC · Daytona Beach, FLN66069Vintage Wings Aircraft LLC · Centerpoint, INN6606AMckenna Terence M · Scotts Valley, CAN6606DRegistration Pending · Sturgeon Bay, WIRegistration pendingN6606GRoach Georgia L · Dewitt, ARN6606QAirtrust LLC - 1 - Series 1 Trustee · Sheridan, WYN6606YBlackwell Benjamin D · Scottsdale, AZN66070Obetz Robert S · Manheim, PAN66073Jenkins Jerome D · Gays Mills, WIN66075Malachi Israel · Superior, WIN66077Johnson Jerry L · Lewiston, IDN66079Dacy Patrick J · Huntley, ILN6607AOlson Duane C · Columbus, KSN6607BWhalen Mark P · Millington, MDN6607DVero Technical Support Inc · Pensacola, FLN6607EHoly Cow Flying Club · Fairbanks, AKN6607FRegistered aircraftN66083Bravo Zulu Aviation LLC · Torrance, CAN66084Cummings Steven R Trustee · Wyarno, WYN66085Bellers Aviation Inc · Fremont, CAN66086Barbosa Manuel Moreira · Apple Valley, MNN66088James M Carrigan LLC · Sanibel, FLN66089Powell Brett · Bennett, CON6608AMarquardt Ashley F · Anchorage, AKN6608DAmericus Flying Club Inc · Americus, GA
Back to AD 79-10-14 R1