Registered aircraft · 72,007

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N3145MWright Jeffrey Crandel · Opelika, ALBuilt 1992 · S/N L001 N31465Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1979 · S/N 2198 N3146LGarnett Robert A · Drewsey, ORBuilt 1992 · S/N 595 N3146SBell Stephen Francis Trustee · Ponte Vedra, FLBuilt 2005 · S/N 40047 N31474Nemeroff Jason R · Scappoose, ORBuilt 1979 · S/N 2205 N31475Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 2207 N3147DOrr Calvin L · Higginsville, MOBuilt 1968 · S/N 32-40412 N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447 N3147ZNeudorf Robert H · Alamogordo, NMBuilt 1959 · S/N 22-7094 N31482First Flight Aero LLC · Reno, NVBuilt 1980 · S/N 2218 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 N314AKTremble Toby K · Wasilla, AKBuilt 2024 · S/N 1001 N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557 N314DBButler David Trustee · Palos Park, ILBuilt 2004 · S/N 921 N314EPHeadings Andrew R · Blue River, WIBuilt 1998 · S/N 24378 N314FRHawkeye Helicopter LLC · Lyndon, KSBuilt 1998 · S/N 18280260 N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774 N314JASharp Jerry L · Georgetown, TXBuilt 1984 · S/N 828 N314JBBratton Johnny B · Williamsport, TNBuilt 1999 · S/N 2843226 N314K314-K Associates LLC · Stratford, CTBuilt 1983 · S/N 31-8352025 N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391 N314MAircraft Partner Holdings Inc Trustee · BerlinBuilt 2010 · S/N 524-2010 N314MEJfw Ranch Consulting LLC · Albuquerque, NMS/N T20608222 N314MFGobel Victor M · White City, ORBuilt 2023 · S/N JA5980920 N314PTStrong Thomas W · Rigby, IDBuilt 2006 · S/N 90489 N314PWJ&S Corley LLC · Peoria, AZBuilt 2000 · S/N 2844031 N314REvans Randall B Trustee · Fallon, NVBuilt 1998 · S/N 399-98 N314RARochester Air Center LLC · Canandaigua, NYBuilt 1998 · S/N 17280489 N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038 N314RVRegistered aircraftBuilt 2007 · S/N 802 N314SAAeryn Innovations LLC · Dallas, TXBuilt 2003 · S/N 18281243 N314SEZaludek Joseph S · Eugene, ORBuilt 2003 · S/N 40.328 N314SHGrover Arlan K · Aurora, COBuilt 1999 · S/N 114 N314SRRoesler Scott D · Homer, AKBuilt 1989 · S/N 314 N314SYDeas James A · Independence, ORBuilt 2013 · S/N 72973 N314TRShalexco LLC · Salt Lake City, UTBuilt 1979 · S/N R18201086 N314TSSteele William G · Warrenton, VABuilt 2003 · S/N 80877 N314YOlson Allen J · Ludington, MIBuilt 1975 · S/N 69 N3150WRegistration Pending · Olympia, WARegistration pendingBuilt 1979 · S/N VAC-126-79 N31519Aerobatics Unlimited · Utica, ILBuilt 1981 · S/N 2250 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 N31536Island Air Taxi LLC · Put In Bay, OHBuilt 1978 · S/N 32-7840132

Back to AD 87-10-06 R1