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.

N52823Sloop Danny H · Rockwell, NCBuilt 1977 · S/N 177RG1279 N52825Thomas James C · Elkhorn, WIS/N 177RG1280 N52828Jacobson Marc A · Madison, WIS/N 177RG1281 N52829Western Heights LLC · Boise, IDBuilt 1974 · S/N 18262879 N5282BStewart Ronald G · Douglas, MABuilt 1979 · S/N 15283826 N5282KBaer Monte Wayne · Ronan, MTS/N 17274042 N52831Truck Guy Inc · Coweta, OKS/N 177RG1282 N52836Payne Thomas E · Old Forge, NYBuilt 1974 · S/N 18262885 N52837Registration Pending · West Warwick, RIRegistration pendingBuilt 1981 · S/N 17274617 N52838Benham Aviation LLC · Enid, OKBuilt 1977 · S/N 177RG1284 N52839Cardinal Flyers LLC · Farmington, MOBuilt 1977 · S/N 177RG1285 N5283EYummy Apple LLC · Mesa, AZBuilt 1978 · S/N 17271812 N5283JMarianas Air Transfer Inc · Tinian, MPBuilt 1980 · S/N 17273754 N5283KNorthwest Wings LLC · Hillsboro, ORBuilt 1980 · S/N 17274043 N5283NGibson Bruce S · Cayucos, CABuilt 1980 · S/N 18267617 N5283RFellow Ship Aviation LLC · Monticello, GABuilt 1974 · S/N 17263497 N52841Skywarrior Flight Training Inc · Pensacola, FLS/N 17274618 N52842Hayes Chris L · Kenai, AKBuilt 1981 · S/N 17274619 N5284DCharlie Lima 1 LLC · Jacksonville, FLBuilt 1979 · S/N 17272493 N5284EIntermill Alice R · Volga, SDBuilt 1978 · S/N 17271813 N5284KSmith Nathan C · Kenai, AKBuilt 1975 · S/N 180-52598 N5284NMiller Kevin A · Littleton, COS/N 18267618 N5284QWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261776 N5284RDahlke Philip H · Smyrna, GABuilt 1974 · S/N 17263498 N5284TSinclair James Stanley · Douglas, GAS/N R18201848 N5284UCochrane Timothy A · Chippewa Lake, OHBuilt 1964 · S/N U206-0284 N5284VMaznicki Frank W · Fort Lauderdale, FLBuilt 1980 · S/N 172RG0494 N52851Mcnamee Brian E · Pompano Beach, FLBuilt 1977 · S/N 177RG1287 N52852Hultin Ronald · Rosemount, MNBuilt 1974 · S/N 18262897 N52853Heintz David A · Culver, ORS/N 18262898 N52857Tdex Equipment · Abilene, TXBuilt 1974 · S/N 18262901 N52859Wehrs Aviation LLC · Johnsburg, ILBuilt 1974 · S/N 18262903 N5285DBarker Aviation LLC · Ardmore, OKBuilt 1958 · S/N 50183 N5285HChild Cris · Mapleton, UTBuilt 1975 · S/N 17265395 N5285KBoland Mark J · Anchorage, AKBuilt 1980 · S/N 17274045 N5285QBartell Kevin W · Abbottstown, PABuilt 1972 · S/N 15073185 N5285RPuddle Jumper Aviation LLC · Brighton, COS/N 18503027 N5285UShroyer Jayme D · Longmont, COBuilt 1964 · S/N U206-0285 N5285VMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1980 · S/N 172RG0495 N52861Holst Thomas C · Pleasant Hope, MOBuilt 1974 · S/N 18262904 N52862Klosterman Sean M · Seattle, WABuilt 1977 · S/N 177RG1290 N52863Swodeck John · Gilbert, AZS/N 18262906 N52866Egan Bailey J · Forsyth, MTBuilt 1974 · S/N 18262909 N5286EButler Bill · Juntura, ORBuilt 1978 · S/N 17271815 N5286HNieves Irvyn T · Vega Baja, PRBuilt 1975 · S/N 17265396 N5286PSzabo Arthur J · Hurley, NYBuilt 1981 · S/N 15284907 N5286QPasterski Mark F · Chicago, ILBuilt 1972 · S/N 15073186 N5286TWilson Aviation LLC · Robinson, ILBuilt 1984 · S/N R18201849 N52871North Cardinal LLC · Crookston, MNBuilt 1977 · S/N 177RG1294 N52873Pepper Daniel J · Henderson, TXBuilt 1974 · S/N 18262916

Back to AD 87-20-03 R2