Skip to content

Registered aircraft · 72,003

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.

N11968Good Guys Finish First Inc · Colorado Springs, COS/N 17702383 N11969Brookings Aerosports Unlimited Inc · Brookings, SDS/N 10126 N1196AAust Properties LLC · Ocean Springs, MSBuilt 1992 · S/N 10103 N1196CGlenn Nathan Eric · Bay City, TXBuilt 1992 · S/N 10108 N1196GHoward Jerry · Wellton, AZBuilt 1992 · S/N 10110 N1196JSalem Pilots Association · Salem, ORBuilt 1992 · S/N 10112 N1196LLindsey Robert H · Savannah, TNS/N 10113 N1196TMay Justin · Acton, MABuilt 1992 · S/N 10116 N1196USwaff Properties LLC · Humble, TXBuilt 1976 · S/N 17266897 N1196WGrand Sarfari Productions LLC · Middletown, DEBuilt 1992 · S/N 10118 N1196XMedic Choppers LLC · Springdale, ARS/N 28-7525279 N1197GFlying Tigers Flight School Ltd · Houston, TXBuilt 1992 · S/N 10104 N1197PPenley Steven A · Corinth, TXBuilt 1955 · S/N 23-212 N1197QSmoke Seen LLC · Farmingdale, NYBuilt 1992 · S/N 10138 N1197UP D H S Aerial Photography Inc · St Petersburg, FLBuilt 1976 · S/N 17266898 N1197ZAegis Protective Services LLC · Broken Bow, OKBuilt 1993 · S/N 10151 N1198UFico Dennis · East Northport, NYBuilt 1993 · S/N 10167 N1198XDiscover Aviation Center LLC · Elyria, OHBuilt 1975 · S/N 28-7505223 N11999Euroaviation Inc Trustee · KematenBuilt 1989 · S/N 25-1213 N1199EThibodeaux Brian A · Eagle River, AKS/N 254-77 N119A2is Partners LLC · Vero Beach, FLBuilt 1969 · S/N 28-25947 N119AVFour Mac Air LLC · San Diego, CAFirst renewal noticeBuilt 1984 · S/N 28-8490079 N119AZTuozzolo Thomas J · Lakewood Ranch, FLBuilt 2004 · S/N 70032 N119BCW D Investments LLC · Sammamish, WAS/N 499-2007 N119BSDrinkall Jamey L · Nampa, IDBuilt 2012 · S/N 70517 N119BTDelaware US Investments LLC · Corpus Christi, TXBuilt 2022 · S/N 2881522 N119CCCranor Clayton L · North Pole, AKBuilt 1974 · S/N 18-7409126 N119CMSahm Ralph K · Santa Clara, CABuilt 1987 · S/N 00001 N119DBWalker John D · Neosho, MOFirst renewal noticeBuilt 1998 · S/N 081 N119DCDuque Helen · Orlando, FLS/N 17267722 N119EAce Aeromotive Inc · Miami, FLBuilt 1958 · S/N 24-532 N119EKBrady Michael K · Sammamish, WABuilt 1974 · S/N AA5-0595 N119FFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1993 · S/N 119 N119FRJeffery & Weiss Holdings LLC · Long Beach, CAS/N 17276535 N119GMLai LLC · Flowood, MSS/N 1 N119GSDall James R Jr · Hayes, VABuilt 1985 · S/N 32R-8529009 N119HPValiair Limited Company Trustee · Casper, WYBuilt 1966 · S/N 28-21570 N119JDUSA Wiltshire LLC · Pembroke Pines, FLBuilt 1969 · S/N 28-25406 N119JMEverything Pitts LLC · Queen Creek, AZBuilt 1981 · S/N 2251 N119KRc Stone LLC · Willacoochee, GABuilt 2004 · S/N T18208232 N119KSKent State University · Stow, OHBuilt 1999 · S/N 17280823 N119KWWiechman Byron T · Wichita, KSBuilt 2025 · S/N 03220242 N119LSMarsair LLC · Franklin, WIBuilt 2002 · S/N 18281119 N119MMiceli Christopher N · Ocean Springs, MSBuilt 1998 · S/N 25250 N119NMcmillan Joseph W · West Grove, PAS/N TTN-51 N119SGSantangelo Joseph A · Johnstown, NYBuilt 2002 · S/N 1329-2002 N119STSandberg Brian · Lancaster, CABuilt 1975 · S/N AA5B-0119 N119SUSouthern Utah University · Cedar City, UTBuilt 2018 · S/N 523-2018 N119TBFlint Kelley C · Tulsa, OKBuilt 2010 · S/N 71612 N119VKKhrupin Vadim V · Sacramento, CABuilt 2024 · S/N 41056

Back to AD 87-10-06 R1