Skip to content

Registered aircraft · 40,395

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N3140TSuggs Helen T · Jacksonville, FLBuilt 1967 · S/N 17700440 N3140ZHoyt Kenneth B · Marion, KSBuilt 1959 · S/N 22-7084 N3141EPower City Aviation Inc · Hazleton, PABuilt 1978 · S/N 17271449 N3141TN3141t LLC · Saint Johns, MIBuilt 1967 · S/N 17700441 N3141ZKumbier Jenene R · Maxwell, IABuilt 1959 · S/N 22-7086 N31429Leonard Gordon A · Anchorage, AKBuilt 1991 · S/N 20649 N3142TTri State Airmotive LLC · Berryville, ARS/N 17700442 N3143DRoland Ann J · Woodland, CAS/N SA1025-75013LF N3143WLoyd Marion S · Dumas, ARBuilt 1991 · S/N 1920 N3143ZChristian Edward A · Evans, GABuilt 1959 · S/N 22-7088 N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075 N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444 N3144ZWasilowski Richard P · Arlington, WABuilt 1959 · S/N 22-7089 N3145MWright Jeffrey Crandel · Opelika, ALBuilt 1992 · S/N L001 N3146LGarnett Robert A · Drewsey, ORBuilt 1992 · S/N 595 N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447 N3147ZNeudorf Robert H · Alamogordo, NMBuilt 1959 · S/N 22-7094 N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448 N3149QClear Air LLC · Ashford, CTBuilt 1977 · S/N 28-7790439 N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449 N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557 N314EPHeadings Andrew R · Blue River, WIBuilt 1998 · S/N 24378 N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774 N314JASharp Jerry L · Georgetown, TXBuilt 1984 · S/N 828 N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391 N314REvans Randall B Trustee · Fallon, NVBuilt 1998 · S/N 399-98 N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038 N314SHGrover Arlan K · Aurora, COBuilt 1999 · S/N 114 N314SRRoesler Scott D · Homer, AKBuilt 1989 · S/N 314 N314YOlson Allen J · Ludington, MIBuilt 1975 · S/N 69 N3150WRegistration Pending · Olympia, WARegistration pendingBuilt 1979 · S/N VAC-126-79 N3151EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271453 N3151RBergstrom Danny · Stillwater, MNBuilt 1982 · S/N 353 N3151XJoseph Stern · Sherman, TXS/N 17702399 N3151ZOld Crow Flyers LLC · Mooresville, NCBuilt 1959 · S/N 22-7098 N3152ZMoultrie Zachariah D M · Grass Valley, CABuilt 1959 · S/N 22-7096 N31531Storey James F · Gadsden, ALBuilt 1978 · S/N 28-7816558 N31532Delaware Valley Aviation Inc · Langhorne, PABuilt 1978 · S/N 28-7890468 N3153HChristensen David R · Brigham Cit, UTBuilt 1982 · S/N 663 N3153TRegistered aircraftBuilt 1967 · S/N 17700453 N3155SSterling Flight Training LLC · Jacksonville, FLBuilt 1978 · S/N 28-7890525 N3155TRobbins Charles R · Trout Creek, MTBuilt 1967 · S/N 17700455 N31563Hfd Aviation LLC · Salem, VABuilt 1978 · S/N 28-7816561 N31565Datema Steven K · Susanville, CABuilt 1978 · S/N 28-7816563 N3156PLumley William · Delray Beach, FLBuilt 1957 · S/N 23-1087 N3156TSpring Mitchell L · Saint Cloud, FLBuilt 1967 · S/N 17700456 N3156ZSale Reported · Wellsville, UTSale reported, canceledBuilt 1959 · S/N 22-7103 N3157THollrah Kenneth R · Enid, OKBuilt 1967 · S/N 17700457 N3157ZIvy James E · Alba, TXS/N 22-7104 N31581Lesher Jesse L · Walton, KYBuilt 1978 · S/N 28-7816565

Back to AD 79-10-03 R2