Registered aircraft · 56,578

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

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

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.

N235MERegistered aircraftBuilt 2000 · S/N 18280753 N235NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274911 N235PXGons Stephen E · Camp Hill, PABuilt 2022 · S/N 18283176 N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206 N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797 N2360ARegistration Pending · Cedar Falls, IARegistration pendingS/N 20608016 N2360CCkt Aviation LLC · Anchorage, AKBuilt 1953 · S/N 30660 N2360GVath Edward V · Acton, CABuilt 1958 · S/N 51660 N2361GMcmanigle Jeffrey M · Osakis, MNBuilt 1958 · S/N 51661 N2362CCelek Brian F · Charleston, SCBuilt 1999 · S/N 18280474 N2362JBauer Bryce · Forestville, CABuilt 1999 · S/N 18280475 N2362RBarone Christian · Stratham, NHBuilt 1964 · S/N 18255462 N2362SMclaren Institute Of Transporation Technologies · Goode, VABuilt 1967 · S/N 337-0662 N2362XFort Scott Family Medicine Pa · Fort Scott, KSBuilt 1965 · S/N 18256262 N2363DCross John P · Houston, TXBuilt 1952 · S/N 20515 N2363FColumbus State Community College · Columbus, OHBuilt 1964 · S/N 21058563 N2363GSawaya Mark C · Spring Valley, CABuilt 1958 · S/N 51663 N2363KJerk Assets LLC · Bakersfield, CABuilt 2001 · S/N 172S8817 N2363RVertikle Enterprises LLC · Cheyenne, WYBuilt 1964 · S/N 18255463 N2363S182 Skylane LLC · Loxahatchee, FLS/N 18280478 N2363XShort Joe · Clintwood, VABuilt 1965 · S/N 18256263 N2363YPlane Pro Aviation LLC · Shelby, NCBuilt 1967 · S/N 17700163 N2364CMeinershagen Charles I · Redding, CABuilt 1953 · S/N 30664 N2364FCarlson David G Trustee · Cape Fair, MOBuilt 1964 · S/N 21058564 N2364GTveitnes Svein T · Whitewright, TXBuilt 1958 · S/N 51664 N2364RRegistered aircraftBuilt 1964 · S/N 18255464 N2364XElkhorn Aviation LLC · Norfolk, NEBuilt 1965 · S/N 18256264 N23655Redline Aviation LLC · Wilmington, DEBuilt 1998 · S/N 18280378 N2365NDulles Aviation · Bristow, VABuilt 1998 · S/N 18280373 N2366CKase Gayle L · Wasilla, AKBuilt 1953 · S/N 30666 N2366DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 20518 N2366EWerner Service & Trucking Inc · Saint Edward, NEBuilt 1982 · S/N 18268197 N2366GDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 18280379 N2366MWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280447 N2366NKohnen Patrick Kennedy · Flagstaff, AZS/N 18280382 N2366SDaughtrey Kevin E · Arcadia, FLS/N 337-0666 N2366YAvco Patrol LLC · Lyndon, KSBuilt 1999 · S/N 18280539 N23673National Training 1 LLC · Wilmington, DEBuilt 1998 · S/N 17280563 N23675Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1999 · S/N 17280651 N23676A&E Flying Club Of Los Angeles Inc · Hawthorne, CABuilt 1998 · S/N 18280324 N23677Doering Jim · Arcadia, CABuilt 1998 · S/N 18280389 N23678Warner Donald R · Milford, MIBuilt 2007 · S/N 172S10591 N2367DBushey Abel · Barnet, VTBuilt 1952 · S/N 20519 N2367GSahagun Salvador G · Bothell, WAS/N 51667 N2367MPeterson Aviation LLC · Oregon, WIBuilt 1998 · S/N 18280386 N2367X182 Jkp LLC · Fall River, MABuilt 1998 · S/N 18280252 N2368GRegistered aircraftBuilt 1999 · S/N 18280541 N2368SShane LLC · Wilmington, DEBuilt 1999 · S/N 18280390 N2368UPlehn Thomas R · Las Vegas, NVBuilt 1962 · S/N 17249968 N2368XD C T LLC · Wallace, IDBuilt 1965 · S/N 18256268

Back to AD 79-10-14 R1