Registered aircraft · 54,017

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.

N5431SGreensburg Jeanette Airport Administration Inc · Jeannette, PABuilt 1966 · S/N 337-0531 N5431TCorbett Michael T · Lake City, FLBuilt 1964 · S/N 17251331 N54322Myers Robert E · Sperry, OKBuilt 1981 · S/N 17274956 N54324T2xb LLC · Valdosta, GABuilt 1981 · S/N 17274958 N5432BDixon Charles W · Brookhaven, MSBuilt 1956 · S/N 33432 N5432CBarbee James E · Mason Neck, VABuilt 1950 · S/N 19466 N5432EMilwaukee Aero LLC · Milwaukee, WIBuilt 1978 · S/N 17271860 N5432HArmstrong Aviation Services LLC · Freeport, PABuilt 1975 · S/N 17265432 N5432RMishmash Christopher L · Valdez, AKBuilt 1965 · S/N 17252979 N5432VMj Aerial LLC · Wasilla, AKS/N 18257941 N5433BBlue Moon Aviation LLC · Grangeville, IDBuilt 1956 · S/N 33433 N5433EAty Aviation Inc · Watertown, SDBuilt 1978 · S/N 17271861 N5433RJones Kenneth Jr · Lufkin, TXBuilt 1965 · S/N 17252981 N5433XMk Air LLC · Lewistown, MTBuilt 1980 · S/N U20605749 N54346Aviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1981 · S/N 17274959 N5434ASteele Group Insurance Agency Inc · Eugene, ORBuilt 1979 · S/N 21063436 N5434DSierra Lima Aviation LLC · Riverton, UTBuilt 1979 · S/N 17272569 N5434EMiller Shane D · Cherokee, OKBuilt 1978 · S/N 17271862 N5434RFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1965 · S/N 17252982 N5434SAnderas Per R · Green Bay, WIS/N 3370534 N5434VInhouse Graphics Inc · Brookshire, TXBuilt 1975 · S/N 21060947 N54355Elizabeth City State University · Elizabeth City, NCBuilt 1981 · S/N 17274960 N54357Rick Aviation Inc · Newport News, VAS/N 17274962 N5435BMacomber Gregory S · Kalamazoo, MIBuilt 1956 · S/N 33435 N5435EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271863 N5435HWindham Brealon A · Kingsville, TXBuilt 1975 · S/N 17265433 N5435J22december LLC · Bartlett, ILS/N 17273793 N5435QHutchins Kent F · Carbon, INBuilt 1972 · S/N 15073335 N54360A S Flight Academy LLC · Lantana, FLBuilt 1981 · S/N 17274963 N5436AJls Investments Inc · Lafayette, LAS/N 21063437 N5436EKitsap Aviation Squadron Inc · Southworth, WAS/N 17271864 N5436HTrue Course Air LLC · Rich Hill, MOBuilt 1975 · S/N 17265434 N5436QAdler Richard A · Leland, NCBuilt 1972 · S/N 15073336 N5436TStrachn Adam · Lenoir City, TNBuilt 1964 · S/N 17251336 N5436UNewsom William Joel III · Roswell, GAS/N 21064892 N54371Clare Air Services LLC · Saint Johns, MIS/N 17274966 N5437CHand Loraine A · Tahlequah, OKBuilt 1950 · S/N 19561 N5437HBuena Vista Flying Club Inc · Richland Center, WIBuilt 1975 · S/N 17265435 N5437JMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 17273794 N5437QMetro Technology Aviation Campus · Oklahoma City, OKBuilt 1972 · S/N 15073337 N5437RSchafer Brian L · Carleton, MIBuilt 1974 · S/N 17263541 N54381Paradise South Ventures LLC · Marco Island, FLBuilt 1981 · S/N 17274968 N5438BMoore Ryan T · Nampa, IDS/N 33438 N5438ECsp Aviation LLC · Stuart, FLBuilt 1983 · S/N 18268319 N5438TFritz James A · Pierce, NEBuilt 1964 · S/N 17251338 N5439CLopez Hugo E · Mcallen, TXFirst renewal noticeBuilt 1979 · S/N 21063755 N5439HMeyer Aviation Group LLC · Grand Island, NEBuilt 1975 · S/N 17265437 N5439KEastern Kentucky University · Richmond, KYBuilt 1980 · S/N 17274110 N5439RIndian Hills Community College · Ottumwa, IABuilt 1965 · S/N 17252989 N5439TSlone James E · Grundy, VAS/N 17251339

Back to AD 87-20-03 R2