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.

N8599QForbes Paul J · Anchorage, AKBuilt 1976 · S/N U20603454 N8599SMcclung Malcolm J · Ripon, WIBuilt 1966 · S/N 18256699 N8599TRegistered aircraftBuilt 1960 · S/N 52499 N859ALAms Aviation LLC · South Bend, INBuilt 1979 · S/N U206-04888 N859BABarr Air Patrol LLC · Mesquite, TXS/N 18268080 N859DLBryant Charles Martel · Dallas, TXBuilt 1976 · S/N 18503134 N859JANational Aircraft Leasing · Greenville, DEBuilt 2009 · S/N 18282173 N859ZSeneca Flyers Inc · Waterloo, NYS/N 56306 N85AAmerican Aerial Patrol LLC · Gonzales, LAS/N R18200451 N85ACSusten LLC · Austin, TXBuilt 1975 · S/N 18264232 N85ADEagle Eye Produce Inc · Idaho Falls, IDS/N P21000795 N85AJBha Leasing Inc · South Portland, MEBuilt 1977 · S/N 18503424 N85BBennett Dennis Lane Jr · Hastings, MIBuilt 1957 · S/N 33979 N85BPPearce William · Grants Pass, ORBuilt 1961 · S/N 185-0183 N85CFSutton Aircraft Salvage LLC · Palmer, AKFirst renewal noticeBuilt 1971 · S/N 18501904 N85DTPolashenski Christopher · Fairbanks, AKBuilt 1978 · S/N 18503474 N85EFRegistered aircraftBuilt 1974 · S/N 18263109 N85FASilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15283865 N85GH185f LLC · East Troy, WIBuilt 1975 · S/N 18502655 N85GKSale Reported · Yonkers, NYSale reportedBuilt 1962 · S/N 17249512 N85JAFrequency Change Aviation Services Inc · Nashville, TNS/N 17273313 N85JWWhittington Robert W · Blackwell, OKBuilt 1968 · S/N 17257686 N85JXKahonees Air Service LLC · Bozeman, MTBuilt 1973 · S/N 18502298 N85KAMancini Christopher S · Houston, TXBuilt 1977 · S/N 18503404 N85LCCoyote Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502643 N85LZJacques Jerry J · Iliamna, AKBuilt 1975 · S/N 18502777 N85NEvans Thomas P · Hollow Rock, TNBuilt 1966 · S/N 18257256 N85PEMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N U20602774 N85QAmiculum LLC · Black Eagle, MTBuilt 1978 · S/N 18503703 N85RN85 Romeo Group Lp · Wildwood, MOBuilt 1978 · S/N 18266494 N85SJSweet Jesus LLC · Ridgely, MDBuilt 1959 · S/N 52280 N85SNSn Inc · Seattle, WAS/N 18501844 N85SSCornelius John W · Elgin, TXBuilt 1966 · S/N 15064568 N85TBurbanks Travis · Woodland Hills, CABuilt 1960 · S/N 18253094 N85VBRegistered aircraftS/N 18263905 N85XYWilliams Jerome L · Forkland, ALBuilt 1977 · S/N 18503370 N8600BGold Daniel A · North Pole, AKBuilt 1957 · S/N 36300 N8600GHunter Brian D · Scranton, IAFirst renewal noticeBuilt 1965 · S/N 15062700 N8600UCristiano Thomas J · Clifton Park, NYBuilt 1976 · S/N 15077957 N8600ZChamberlin Aviation · East Wenatchee, WABuilt 1967 · S/N P206-0400 N8601BKorta Stephen E · Poplar Grove, ILS/N 36301 N8601GRamakrishna Murali DBA · Burlington, MABuilt 1966 · S/N 15062701 N8601SDykstra Wayne A · Pipestone, MNS/N 15061901 N8601TSmalley Roger A · Medford, ORBuilt 1960 · S/N 52501 N8601UKing Stephen M · Trout Lake, WABuilt 1965 · S/N 17252501 N8601ZMagnolia Springs Properties Inc · Kirbyville, TXS/N P206-0401 N86020Yamnik Alexander E · Glencoe, MNBuilt 1969 · S/N 337-1054 N8602BShannon Terrence M · Kuna, IDBuilt 1957 · S/N 36302 N8602TReed James E · Inverness, MSBuilt 1960 · S/N 52502 N8602UAllegood Jerry C · Moultrie, GABuilt 1965 · S/N 17252502

Back to AD 87-20-03 R2