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.

N1636FRolfe Harold B Trustee · Holtville, CABuilt 1966 · S/N 17255031 N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672 N1636YHokanson Anthony Drake · La Crosse, WIBuilt 1962 · S/N 17249336 N1637CAshby Clark S · Pleasant Grove, UTBuilt 1953 · S/N 30337 N1637EJag Flying Club Inc · Morgantown, WVBuilt 1978 · S/N 17271077 N1637FLaminar Skies Aviation LLC · Broken Arrow, OKS/N 17255032 N1637YSmartt Kevin M · Springfield, TNBuilt 1962 · S/N 17249337 N1638FKeith Frye · El Dorado, KSS/N 17255033 N1638QBeck Michael C · Farmington, CTBuilt 1971 · S/N 15072938 N1639DVoigt Don M · Palmer, AKBuilt 1952 · S/N 20281 N163CLJust Saying Construction LLC · Merritt Island, FLS/N 21062122 N163HJ&L Asset Holdings LLC · Biloxi, MSBuilt 1957 · S/N 34049 N163LASimeon Sound LLC · Aguilares, TXBuilt 1967 · S/N 15067645 N163MCCriddle Michael J · Baker, FLBuilt 1963 · S/N 17250149 N163RHHollis Richard H · Auburn, MES/N 18051307 N163WDavis Paul J Jr · Springdale, ARBuilt 1956 · S/N 27094 N1640DRoessler Larry J · Groveland, CABuilt 1952 · S/N 20282 N1640EBanan Abdolreza · San Diego, CABuilt 1978 · S/N 17271078 N1640YHall Justin J · Bellevue, NEBuilt 1962 · S/N 17249340 N1642FRomeo Kilo Golf LLC · Asheville, NCBuilt 1966 · S/N 17255037 N1642QTochman Andrew J · Avon Lake, OHBuilt 1971 · S/N 15072942 N1643DMaselko Jacek · Juneau, AKBuilt 1952 · S/N 20285 N1643YLehman Patrick A · Phillips, WIBuilt 1962 · S/N 17249343 N1644CAero 290 LLC · Burlington, WIBuilt 1953 · S/N 30344 N1644EMountain Flyers Inc · Hendersonville, NCBuilt 1979 · S/N 17271079 N1644MBrown James E · Duluth, MNBuilt 1970 · S/N 18501847 N1644QBell Norman O · Hurlock, MDBuilt 1971 · S/N 15072944 N1644YPopple Timothy J · Osseo, WIS/N 17249344 N1645CRoach Aviation LLC · Longview, TXBuilt 1953 · S/N 30345 N1646DDraggin Tail Pilots · Prospect, PAS/N 20288 N1646FBowman Nathaniel Ryan · Wildwood, MOBuilt 1966 · S/N 17255041 N1646QOwens Wilbur · Rancho Palos Verde, CAS/N 15072946 N1646YMinion Air · John Day, ORBuilt 1962 · S/N 17249346 N1646ZDmitry P Kudryn · Wasilla, AKBuilt 1962 · S/N 185-0446 N1647DExpress Aviation Management LLC · Dover, DES/N 20289 N1647FBlue Sky Rentals LLC · Hermiston, ORBuilt 1966 · S/N 17255042 N1647MAmerimed Aviation LLC · Buford, GABuilt 1975 · S/N 18264400 N1647YRudolphi William A · Doylestown, PAS/N 17249347 N1647ZSantana Barry W · Wasilla, AKBuilt 1962 · S/N 185-0447 N1648FBahizi Pierre Ntwali · Sterling, VAS/N 17255043 N1648MForsberg Aviation Inc · Elk Grove, CABuilt 1975 · S/N 18264401 N1648QPlane Connection LLC · New Bern, NCBuilt 1971 · S/N 15072948 N1648YSutton Aircraft Salvage LLC · Palmer, AKBuilt 1962 · S/N 17249348 N1649FWalton Amber · Upper Sandusky, OHS/N 17255044 N1649MMitten Aero LLC · Lexington, MIS/N 18264402 N164JDDominik James W · Golf, ILBuilt 1966 · S/N 18051816 N164JMWind Sand & Stars Aviation LLC · San Diego, CABuilt 1978 · S/N R18200158 N164VPConservation Aviation LLC · Washington, DCS/N U20601942 N1650CBrokaw Samuel J · South Bend, INBuilt 1953 · S/N 30350 N1650F4 Aces Air LLC · Brandon, MSS/N 17255045

Back to AD 87-20-03 R2