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.

N41859Morale Joseph D · Dallas, TXBuilt 1974 · S/N 28-7405145 N4185WJames William S · Orange Park, FLBuilt 2001 · S/N 2843417 N4185XWjw Transport Inc · Hampshire, ILBuilt 2000 · S/N 3257195 N4185ZHill Leslie E · Patten, MEBuilt 1966 · S/N 18-8370 N41866Racy Equipment Leasing LLC · Tucson, AZBuilt 2000 · S/N 3257177 N41867Stevens Charles O · Columbus, MSBuilt 1974 · S/N 28-7415340 N4186ZSturgeon Ronald A · Anchorage, AKBuilt 1966 · S/N 18-8371 N41874Tailwinds Leasing LLC · Missoula, MTBuilt 1999 · S/N 4636230 N4187HMcalister Aviation LLC · Greenwood, ARBuilt 2000 · S/N 3257196 N4187JPeterson Erik J · Revillo, SDBuilt 1967 · S/N 28-22526 N4187QAggie80 Air LLC · Richmond, TXBuilt 2001 · S/N 3257214 N4187RAnkrum Donald Larry · Hemet, CABuilt 1968 · S/N 32-40522 N4187YStohr Beuford G · Woden, IABuilt 1977 · S/N 289-77 N4187ZPickus Norman F · Fairbanks, AKBuilt 1966 · S/N 18-8372 N41880Brown Terry K · Eddyville, IABuilt 1974 · S/N 28-7425292 N41882Monroe Robert E · Navarre, FLBuilt 1974 · S/N 28-7415345 N41888Lanyi Clifford M · Attleboro, MABuilt 1974 · S/N 28-7415348 N4188ASky Magic LLC · Helena, MTBuilt 2000 · S/N 4636296 N4188DMachine Leasing · Kent, WABuilt 1999 · S/N 4636220 N4188JLaib Aaron B · Emporia, KSS/N 23022 N4188PAero Club Valkaria LLC · Malabar, FLS/N 23-1676 N4188TBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843124 N4188ZDanielson Debra · Skillman, NJBuilt 1966 · S/N 18-8373 N41896Hoffman Rick · Buckley, WABuilt 1974 · S/N 28-7415349 N41897Unlimited Upside LLC · Boggstown, INBuilt 1974 · S/N 28-7415350 N4189APelton Ag Inc · Burdett, KSBuilt 2003 · S/N 3255007 N4189PAdams Carlos · Hawi, HIS/N 23-1677 N4189RFarr Fly LLC · Wilmington, DEBuilt 1968 · S/N 32-40525 N418AAAltitude & Anchor LLC · Kalispell, MTS/N 0582 N418ALMckeen Alan P · Liverpool, NYBuilt 1997 · S/N 23130 N418CBDallas Aero & Sales LLC · Poplar, MTBuilt 2001 · S/N 2144 N418CCRedfield James A · Simi Valley, CABuilt 1976 · S/N 17702464 N418DBNewton Thomas L Jr · Fredericksburg, VABuilt 1974 · S/N 6737 N418DCCunningham Dan · Bismarck, ILBuilt 1998 · S/N 331 N418FLKinney Richard · West Des Moines, IABuilt 1971 · S/N 28-7125197 N418FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC018 N418JTDavies Lloyd G · Orofino, IDBuilt 1978 · S/N 13123 N418KMMassimini Sebastian Vince · Arlington, VABuilt 2002 · S/N 25075C N418LGm Farm Service LLC · Santa Teresa, NMBuilt 1978 · S/N R18200821 N418PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843414 N418PRHunnicutt Gerald E · Hendersonville, NCBuilt 1978 · S/N R18200475 N418RLChant Andrew P · San Francisco, CABuilt 2004 · S/N RG002 N418SRegistered aircraftBuilt 2001 · S/N 60121 N418SLLagergren Steven R · Litchfield, MNFirst renewal noticeBuilt 2011 · S/N 70419 N418STDoan Michael C · Phoenix, AZFirst renewal noticeBuilt 2018 · S/N MR411 N418TASale Reported · Lancaster, TXSale reported, pending cancellationS/N 680105 N418TJFive Star Family Aviation LLC · Yorkville, ILBuilt 1977 · S/N 28-7890086 N418WKMenger Charles C Jr · Wills Point, TXBuilt 2002 · S/N 20735 N418WRBeegles Aircraft Service LLC · Greeley, COBuilt 1997 · S/N 18280034 N418XMerrell Robert H · Farmington, NHBuilt 1976 · S/N 7042C

Back to AD 87-10-06 R1