Registered aircraft · 72,010

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.

N379NLDe Av8r LLC · Lewes, DEBuilt 1978 · S/N AA5B0822 N379PFRegistered aircraftS/N 15069689 N379SSky Chasers LLC · Mount Vernon, WABuilt 1980 · S/N R18201681 N379XCjr Air Service LLC · Saint Louis, MOBuilt 1976 · S/N 7011C N37AGWalker Robert J · West Finley, PABuilt 1990 · S/N AG-5 N37ARFlowers Charles L · Yelm, WABuilt 1999 · S/N 1134 N37AWCcx-2000-0111 LLC · Garberville, CABuilt 1999 · S/N 2020 N37BHHuelsman Bradley D · Dayton, OHBuilt 1996 · S/N AE92-101 N37BKChanging Horizons LLC · Helena, MTBuilt 2004 · S/N 10542 N37BTStucki Andre O · Deerfield Beach, FLBuilt 1981 · S/N 32R-8113083 N37BYTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 951-2004 N37CKRichardson Dean · Saint Thomas, VIBuilt 1962 · S/N 500A-1251-76 N37CPRegistered aircraftBuilt 2012 · S/N 40795 N37DAero Equities LLC · Ventura, CABuilt 1973 · S/N 570-73 N37DKPreston Richard R Trustee · Albuquerque, NMBuilt 1978 · S/N GA7-0030 N37DMWilliams Arzania S · Bolingbrook, ILBuilt 1968 · S/N 28-25245 N37DNAshmore Seth S · Scottsboro, ALS/N 1030 N37ELLee Ed C · Lancaster, SCBuilt 2002 · S/N 90361 N37EZCaulkins John · Bay Village, OHBuilt 2003 · S/N 2198L N37FLN37fl LLC · Port Saint Lucie, FLBuilt 2020 · S/N 41658 N37GCKoumi Enterprises LLC · Houston, TXBuilt 2002 · S/N 3257273 N37GGAvco Patrol LLC · Lyndon, KSBuilt 1999 · S/N 18280353 N37GWSale Reported · Webster, MNSale reportedBuilt 2017 · S/N 50 N37HMRegistration Pending · West End, NCRegistration pendingBuilt 1981 · S/N TRGR-1 N37HYRegistration Pending · Wasilla, AKRegistration pendingBuilt 1999 · S/N 2037 N37JJMamuzich Robert J Jr · Ocala, FLBuilt 1987 · S/N 1243 N37JNWings As Eagles Mission Air Service Inc · Oshkosh, WIBuilt 1997 · S/N 5373 N37KFFillips Karl · Alvin, TXS/N 317-77 N37LMMay Richard A · Fort Mill, SCBuilt 1971 · S/N 170 N37LVLegros Aviation Services Inc · Crowley, LABuilt 1992 · S/N 695-92 N37MFMueller Martin S · Coeur D Alene, IDS/N FREEMAN S T #1 N37MLLacher Meldon J · El Cajon, CABuilt 1999 · S/N 001 N37MVMonreal Michael · North Barrington, ILBuilt 1969 · S/N 32-40657 N37MZHamm George W Trustee · Fort Worth, TXBuilt 2013 · S/N 70628 N37NCGlace Charles L · Spartanburg, SCBuilt 2010 · S/N 1079 N37NERotor Technologies Inc · Nashua, NHBuilt 1994 · S/N 2450 N37PVan De Pol John M · Amherst, TXS/N 21564 N37PKThill James L · Leesburg, VABuilt 2001 · S/N 80890 N37PRS & R Planes LLC · Tulsa, OKBuilt 1950 · S/N 18-90 N37REGiroux Aeronautical Company LLC · Fulton, NYBuilt 1976 · S/N 32R-7780114 N37RHRegistered aircraftBuilt 1995 · S/N 22585 N37RKWardrop Donald Alexander · Bay Springs, MSBuilt 1985 · S/N 482 N37RNCicero John · Concord, CABuilt 2014 · S/N 90207 N37RPPearson Landon S · Madison, SDBuilt 1992 · S/N 811-6 N37RRWarshauer Holdings LLC · Atlanta, GAS/N PX1520006 N37RTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1997 · S/N 4636082 N37RWCitabria Aces LLC · Virginia Beach, VABuilt 1981 · S/N 969 N37SACampbell John R Trustee · Saint Leo, FLBuilt 1972 · S/N 34-7250046 N37SEPacific Northwest Aircraft Leasing Inc · Meridian, IDBuilt 2001 · S/N 17281035 N37SGGroce Steven F · Springfield, MOBuilt 2001 · S/N 6050

Back to AD 87-10-06 R1