Registered aircraft · 72,001

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.

N159RVTullos George E · Madison, MSFirst renewal noticeBuilt 2003 · S/N 90362 N159TMKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2002 · S/N 462-2002 N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159 N15ADDurrent Aviation LLC · Anchorage, AKBuilt 1978 · S/N 18-7809065 N15AFRogers Jeff · Harrogate, TNBuilt 1976 · S/N 17267237 N15AGOber John A · Candor, NYBuilt 1966 · S/N 349 N15BCWingsleasing LLC · Wichita, KSBuilt 1964 · S/N 28-1712 N15BEAvalon Aviation USA Corp · Murfreesboro, TNBuilt 1981 · S/N R18201806 N15BKBauer Mike · Little Rock, ARBuilt 1985 · S/N D.G.A.1 N15BREllis David E Jr · Midlothian, TXBuilt 1978 · S/N 32R-7880004 N15CASpirit Of Life Ministries International Inc · Carthage, TXBuilt 2005 · S/N 3257401 N15CBAaviation LLC · Telford, PABuilt 1976 · S/N 28R-7635291 N15CHOrlando Flight Academy Inc · Apopka, FLBuilt 1974 · S/N 28-7415277 N15CKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 10012C N15CMCarolina Aero Group LLC · Youngsville, NCBuilt 2004 · S/N 2280 N15CZSafe Aero LLC · Fort Myers, FLBuilt 2005 · S/N 72 N15DEVlazny Stephen F · Divide, COBuilt 1992 · S/N 1 N15DVJoiner Robert W · Worton, MDS/N SDV-RJ-02 N15EASwanson Blake J · Ketchum, IDBuilt 2001 · S/N T20608333 N15EMBranson Tristan · Etna, CABuilt 1972 · S/N 207 N15ESCyr Gregory A · Augusta, MEBuilt 1988 · S/N 001 N15EXRich David R · Glastonbury, CTS/N 5496 N15FGarvin Neal R · Avon, CTBuilt 1997 · S/N 001 N15FACivil Air Patrol · Maxwell Afb, ALBuilt 1978 · S/N 17270117 N15FBPropit Inc · Wilmington, DES/N 018 N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112 N15FPFoxtrot Papa LLC · Slidell, LABuilt 1977 · S/N 17268574 N15FYEsselme Aeronautics & Astronautics LLC · Annapolis, MDBuilt 2006 · S/N 71328 N15GLTubb Jeffrey Scott · Farmington, NMBuilt 2016 · S/N 1209 N15GVCloud 916 LLC · Dover, DEBuilt 2000 · S/N 1297-2000 N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161 N15HJMorehouse Cooper · North Pole, AKS/N 17268950 N15HUBratton Gary · Poteau, OKBuilt 1996 · S/N 1318 N15JEPremier Flight Center LLC · Hartford, CTBuilt 1964 · S/N 27-2494 N15JWTri-Cap International · Roanoke, TXBuilt 1959 · S/N TD-225 N15KFH Aviation LLC · Celina, TXBuilt 1980 · S/N 32-8006073 N15KYMcdougle Sean · Oklahoma City, OKBuilt 1965 · S/N 27-2780 N15LFNorthrup George William · Ellicottville, NYBuilt 1998 · S/N 1395 N15LRBoggs James A · Tucson, AZBuilt 1994 · S/N 1309 N15LWIsaak Robert J · Pocatello, IDBuilt 2001 · S/N 90016 N15MHRegistered aircraftBuilt 1979 · S/N 6107338062145 N15NBMorris Russell K · Cameron Park, CABuilt 1978 · S/N AA5B0974 N15NFRegistered aircraftBuilt 1969 · S/N 17258204 N15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 172RG0115 N15PCCarr Patrick L · Fairmont, WVBuilt 1997 · S/N 1214 N15PJBreedlove Ernest Dale · Valley Mills, TXBuilt 1999 · S/N 23313 N15PTThyssen Patrick L · Conroe, TXBuilt 2009 · S/N 40257 N15PUNorth Valley Aircraft Inc · Valley City, NDBuilt 1989 · S/N 3015 N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388 N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568

Back to AD 87-10-06 R1