Registered aircraft · 54,019

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N2915FStoffregen Thomas S · Milton, WVBuilt 1966 · S/N 18257015 N2915SKoch Kenneth Scott · Coolidge, AZS/N 15066815 N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104 N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133 N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105 N2916AMetro Service Air Inc · Fairbanks, AKBuilt 1953 · S/N 30116 N2916DWatkins Brad D · Roseburg, ORBuilt 1955 · S/N 26859 N2916FAndros Marketing LLC · Fort Lauderdale, FLBuilt 1966 · S/N 18257016 N2916UJohnson Mark D · Camano Island, WABuilt 1963 · S/N 17250516 N29173Aerial Transport LLC · Wilmington, DEBuilt 1968 · S/N U206-1140 N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828 N2917CParks Joseph S · Wilmington, NCBuilt 1954 · S/N 30817 N2917DYoung Michael E · Munroe Falls, OHBuilt 1955 · S/N 26860 N2917FBennett David D · Clinton, WABuilt 1966 · S/N 18257017 N2917JKnoll David Alexander · Godwin, NCBuilt 1966 · S/N 15065717 N2917SItz LLC · Lusby, MDBuilt 1967 · S/N 15066817 N2917UCelebrate Freedom Foundation · West Columbia, SCS/N 17250517 N29181Wings Of Faith · Stevensville, MTBuilt 1968 · S/N U206-1147 N29186Thoroughbred LLC · Kalispell, MTBuilt 1968 · S/N U206-1151 N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153 N2918EDelpenn Flyers Inc · Dover, DEBuilt 1978 · S/N 17271372 N2918JNiemann Benjamin W · Welton, IAS/N 15065718 N2918KHolmes Ronald W · Kent, ORS/N 18053128 N2918SAbove All Aviation Inc · Goleta, CABuilt 1967 · S/N 15066818 N29190Mountain Helicopters LLC · Salt Lake City, UTBuilt 1973 · S/N 21059830 N2919CRudolph Darren M · Wasilla, AKBuilt 1954 · S/N 30819 N2919FPerez Adolfo · Conroe, TXBuilt 1966 · S/N 18257019 N2919KWoodaire Ltd · Coeur D Alene, IDBuilt 1979 · S/N 18053129 N2919SJust Plane Corp · Kokomo, INS/N 15066819 N291DCT G Dunn Plumbing Inc · Hulls Cove, MEBuilt 1953 · S/N 30110 N291KFTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17260482 N291RPGtr Aero LLC · Moultonborough, NHBuilt 1981 · S/N 17274327 N291SPBarr Air Patrol LLC · Mesquite, TXBuilt 1986 · S/N 18268546 N291YASherman Jason Bradley · Indianola, IABuilt 1956 · S/N 28164 N29204Jms Aviation LLC · Waynesville, OHS/N U206-1162 N29209Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 21059832 N2920DYarbrough Deborah C · Somerville, TNBuilt 1955 · S/N 26863 N2920JRegistration Pending · Powell Butte, ORRegistration pendingBuilt 1966 · S/N 15065720 N2920KBowen Kenneth W · Bainbridge Island, WABuilt 1979 · S/N 18053130 N2920SLea Nathanael E · Olalla, WABuilt 1967 · S/N 15066820 N2920UOtto Mark A · Ludington, MIBuilt 1963 · S/N 17250520 N2920VMorrow William M Jr · Harrison, IDBuilt 1974 · S/N 15076320 N2920YApplegate Susan P · Decatur, TXBuilt 1962 · S/N 18253920 N29210Hawkes Brian R · Hamilton, MTBuilt 1968 · S/N U206-1165 N29217Dawson Adam J · Eveleth, MNBuilt 1968 · S/N U206-1171 N2921AStanford Jeffrey S · Anchorage, AKBuilt 1953 · S/N 30121 N2921CMensink David L · Preston, MNS/N 30821 N2921DErlandson Lloyd V · Hilmar, CABuilt 1955 · S/N 26864 N2921JAndrews University · Berrien Springs, MIBuilt 1966 · S/N 15065721 N29221King Management Systems Inc · Liverpool, TXBuilt 1967 · S/N 17700198

Back to AD 87-20-03 R2