Registered aircraft · 54,015

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.

N66BLLemon Bryant William Jr · Albuquerque, NMBuilt 1981 · S/N 185-04175 N66BTTrazer LLC · Parkland, FLBuilt 1964 · S/N 21058437 N66CEM&S Real Estate Management Inc · Granbury, TXS/N 21061391 N66DFClark Samuel D Trustee · Wilson, WYBuilt 1977 · S/N 210-621-41 N66DTTucker Family Agricultural Co LLC · Kiowa, KSS/N 21058931 N66GAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 20700657 N66GVPearson Robert L IV · Spartanburg, SCBuilt 1974 · S/N 17263861 N66JMRussman Nicholas S · Farmersville, TXBuilt 1981 · S/N 15285251 N66KJBlagg Robert D III · Santa Fe, NMBuilt 1959 · S/N 51861 N66LLLetourneau Duane R · Oconto, WIBuilt 1974 · S/N 15076289 N66MACp Aviation · Santa Paula, CABuilt 1985 · S/N 17276376 N66MEDm Asset Management LLC · Plain City, OHBuilt 1977 · S/N R1722298 N66MJUnited States Air Force (Owner) · Usaf Academy, COS/N 18266399 N66MLBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 21062598 N66MMTake Flyt LLC · Eagle Lake, MNBuilt 1976 · S/N 17266632 N66PArchangel One LLC · Lewes, DEBuilt 1978 · S/N 17270824 N66PRPeterjohn Management II LLC · Pound Ridge, NYBuilt 1980 · S/N 17273879 N66RHBoniek Johann C · Nederland, COBuilt 1972 · S/N U20601873 N66RXRegistered aircraftBuilt 1962 · S/N 18253766 N66TEFly4fun LLC · El Segundo, CABuilt 1978 · S/N P21000154 N66VSEurovation Inc Trustee · KematenBuilt 1979 · S/N P21000421 N66WSDighans Murray · Peerless, MTBuilt 1979 · S/N P210-00363 N6700HNashua Flyers Inc · Nashua, NHBuilt 1975 · S/N 17265543 N6700PAbraham Curtis · Byron, WYBuilt 1978 · S/N P21000200 N6700SAgape Enterprises · Montana City, MTBuilt 1967 · S/N 15067500 N6700TKimmerle David · Blanding, UTBuilt 1963 · S/N 18254862 N6700XAlbert Gregory T · Tucson, AZS/N 21057693 N6701AClarke Christopher E · Cincinnati, OHBuilt 1956 · S/N 28848 N6701FHale James W · Darrington, WAS/N 15063301 N6701SKnipping Richard W Jr · Winterport, MEFirst renewal noticeBuilt 1967 · S/N 15067501 N67022Mccormack James · Mount Jewett, PABuilt 1970 · S/N 17259032 N6702AWitte Troy A · West Plains, MOBuilt 1956 · S/N 28802 N6702ERegistration Pending · Danbury, CTRegistration pendingBuilt 1959 · S/N 56202 N6702FVirnig Joshua B · Deerwood, MNBuilt 1966 · S/N 15063302 N6702HGoetz Terry L · Defiance, IABuilt 1975 · S/N 17265545 N6703AMankovich Douglas P · Punxsutawney, PABuilt 1956 · S/N 28803 N6703FBargabos Julie A · Canastota, NYBuilt 1966 · S/N 15063303 N6703RSteinle Lee M · Jourdanton, TXBuilt 1966 · S/N T210-0103 N6704AKaspar Matthew L · Neenah, WIBuilt 1956 · S/N 28804 N6704EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17272052 N6704FAvistar Media Corporation · Wilmington, DES/N 15063304 N6704GRyan Conner J · Fruita, COS/N 15072204 N6704MBillups Jeff · Eagle, IDBuilt 1975 · S/N 18263806 N6705HKobuk Valley Outfitters Co · Kiana, AKBuilt 1977 · S/N 18503337 N6705MRegistration Pending · Stuart, FLRegistration pendingBuilt 1975 · S/N 18263807 N6705SMiszczak Ethan · Newnan, GABuilt 1967 · S/N 15067505 N6706ALouden Bruce H · Kalispell, MTBuilt 1956 · S/N 28806 N6706EDalley Robert C · Waldron, INBuilt 1959 · S/N 56206 N6706HDairy Air Inc · Wyoming, PABuilt 1975 · S/N 17265547 N6706MBaker Thaddeus J · Elk, WABuilt 1975 · S/N 18263808

Back to AD 87-20-03 R2