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.

N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164 N413NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010006 N413RDDos Amigos Air Service LLC · Carrizo Springs, TXBuilt 2004 · S/N 18281464 N413TCMcbeath Casey A · Shreveport, LABuilt 2005 · S/N T18208423 N413THPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020252 N413WCBradshaw Larry C · Edgewood, TXBuilt 2009 · S/N 91607 N413WPKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1261-99 N413YKGoodner Terry Jack · Port Saint Lucie, FLS/N 818 N413ZPPettinger Tom W · Cody, WYBuilt 2004 · S/N 8-4705 N41402Isofly LLC · Canyon Country, CABuilt 2008 · S/N 1934 N41408Drixhurst Six LLC · Lindon, UTBuilt 1974 · S/N 32-7440088 N4140JStone Raymond M · Moore, OKBuilt 1966 · S/N 28-22464 N4140PRenda Gregory L · Saratoga, CABuilt 1999 · S/N 21064C N4140RStewart Mike F · Chugiak, AKBuilt 1968 · S/N 32-40459 N4140WBird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843228 N4140XOtt Dean R · Carrollton, OHS/N 240 N4140ZMeierotto Jeff T · Two Rivers, AKBuilt 1965 · S/N 18-8213 N41412Walters Haskell L · Gold Hill, NCBuilt 1974 · S/N 28-7415204 N41415Cavins Todd J · Stillwater, OKBuilt 1974 · S/N 28-7405101 N41416Lewis Elijah J · Luthersville, GABuilt 1974 · S/N 28R-7435179 N41419Ater Mark · Greenville, OHBuilt 1974 · S/N 28-7425237 N4141BWright Eric K Sr · Wills Point, TXBuilt 1975 · S/N 75-32-160 N4141GPon Douglas James · Chalfont, PABuilt 1999 · S/N 4636233 N4141KKimminau Jeremy · Sacramento, CABuilt 1967 · S/N 680006 N4141RHard Landing LLC · Fort Pierce, FLS/N 32-40460 N4141UMoss James L · Lansing, IABuilt 1998 · S/N 2843125 N4141ZBalmer Jeffrey A · Crosslake, MNBuilt 1964 · S/N 18-8215 N41421Blue Angel Properties LLC · Poland, OHBuilt 1974 · S/N 28-7415208 N41429Straight Arrow LLC · Kuna, IDBuilt 1974 · S/N 28R-7435180 N4142WDale Mike S · Boise, IDBuilt 1967 · S/N 32-40210 N4142YRegistered aircraftBuilt 1976 · S/N 279-76 N41434Groner Frank · Montrose, ALBuilt 1974 · S/N 28-7415212 N41439Lesher James · Farmington, NMBuilt 1974 · S/N 28R-7435183 N4143ASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843217 N4143PSparrowhawk Aviation · Manvel, TXBuilt 1959 · S/N 23-1624 N4143RCon Air Aviation LLC · Borger, TXBuilt 1968 · S/N 32-40462 N4143USwerczek Gerald Edward Jr · Tallahassee, FLBuilt 1999 · S/N 2843308 N4143XBoeing Co · Renton, WABuilt 1968 · S/N 243 N4143YHasenfus Heidi J · Green Cove Springs, FLBuilt 1977 · S/N 236-77 N4143ZRavenscroft Brant A · Box Elder, SDBuilt 1965 · S/N 18-8221 N41449Maccani Mark J · Bessemer, MIBuilt 1974 · S/N 28-7405104 N4144ETradewind LLC · Wasilla, AKBuilt 1978 · S/N 18-7809084 N4144JMclean Yvonne A · Warfordsburg, PABuilt 1966 · S/N 28-22468 N4144KBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843145 N4144PChandler Air Service Inc · Chandler, AZBuilt 1998 · S/N 2843121 N4144RRacer Investments LLC · Long Beach, CAS/N 32-40463 N4144XSkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843267 N41453Swfl Aviation LLC · Cape Coral, FLBuilt 1999 · S/N 3246148 N41457Aviation Medical Experts LLC · Wilmington, DEBuilt 1974 · S/N 28-7415221 N41459Erick Enterprises LLC · Spreckels, CABuilt 1974 · S/N 28-7415222

Back to AD 87-10-06 R1