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.

N5983MPhilipp Michael W · Thief River Falls, MNS/N 17260945 N5984Eberle Larry L · Humble, TXBuilt 1971 · S/N 18260841 N5984FFct Aviation LLC · Portales, NMBuilt 1968 · S/N 21058984 N5984GClifton Raymond L · Pleasanton, TXS/N 15071484 N5984JZogleman Enterprises Inc · Viola, KSBuilt 1975 · S/N 18263599 N5985ARimes Aviation LLC · Worthngtn Spg, FLBuilt 1956 · S/N 28585 N5985GStanton Aviation Lc · Saint George, UTBuilt 1969 · S/N 15071485 N5985JRuby Crest LLC · Girdwood, AKBuilt 1975 · S/N 18263600 N5986FBingham Darold R · Idaho Falls, IDBuilt 1968 · S/N 21058986 N5987ALong Randy M · Dewy Rose, GABuilt 1956 · S/N 28587 N5987GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801166 N5987JBoerne Flight Options LLC · Boerne, TXS/N A1500287 N5988AHiggins Jeffery D · Minden, NVBuilt 1956 · S/N 28588 N5988BLarsen Christopher S · Pleasanton, CAS/N 33988 N5988TInvestopia Online LLC · Houston, TXS/N 15060688 N5989ABrokaw Terry L · Three Rivers, MIBuilt 1956 · S/N 28589 N5989TKnudtson Bruce A · Sioux Falls, SDBuilt 1964 · S/N 15060689 N598ABBrynelsen Charles R · North Oaks, MNBuilt 1976 · S/N 18503136 N5990EManeuvering Speed Inc · Wilmington, DEBuilt 1978 · S/N 17271980 N5991JSchutes John T Jr · Port St Joe, FLBuilt 1971 · S/N A1500291 N5991TDelima Joseph D · Livermore, CAS/N 15060691 N5992GPerry Aaron O · Piqua, OHS/N 15071492 N5992JLinback Ken R · Niles, MIBuilt 1971 · S/N A1500292 N5993ETss Flying Club Inc · Bethesda, MDBuilt 1978 · S/N 17271981 N5993GSchoenrock Timothy · Stillman Valley, ILBuilt 1969 · S/N 15071493 N5994TBundgard Peter A · Natchez, MSBuilt 1964 · S/N 15060694 N5995AOanes Kenneth W · Merrillan, WIBuilt 1956 · S/N 28595 N5995BWilson Robert E III · Urbanna, VABuilt 1956 · S/N 33995 N5995JYachal Benedick · Wilsey, KSBuilt 1975 · S/N 18263604 N5996ACascade Mountain Vacation Rentals LLC · Cle Elum, WABuilt 1956 · S/N 28596 N5996BStrong Brian S · Southport, NCBuilt 1956 · S/N 33996 N5996FL M W Leasing · Midlothian, TXBuilt 1968 · S/N 21058996 N5996GRandle Jessica R · North Bend, ORBuilt 1969 · S/N 15071496 N5996JEvergreen Flying Club Inc · Medina, WABuilt 1975 · S/N 18263605 N5996ROwens Wilbur · Rch Palos Vrd, CAS/N 17253665 N5996TLopez Manuel G · Fort Washington, MDFirst renewal noticeS/N 15060696 N5997BSpence Joseph H · Enterprise, ORBuilt 1956 · S/N 33997 N5997RVande Sandt Curtis B · Tioga, NDBuilt 1965 · S/N 17253666 N5997TFour Aces Montana LLC · Missoula, MTBuilt 1964 · S/N 15060697 N5998ACrow Todd R · Hinckley, MNBuilt 1956 · S/N 28598 N5998BConroy Bruce M · Martinez, CABuilt 1956 · S/N 33998 N5998FMedic Choppers LLC · Springdale, ARS/N 21058998 N5999BBig Bird LLC · Prescott, AZBuilt 1957 · S/N 33999 N599CMMscm Partners LLC · Fairfield, TXS/N 17257970 N599CPCoons Aircraft Services Inc · West Palm Beach, FLBuilt 1968 · S/N 18258960 N59ABates Roger · Palm Beach Gardens, FLBuilt 1978 · S/N 21062509 N59ADJohnson Rand C · Galveston, TXBuilt 1959 · S/N 46673 N59AJBird Dog Aircraft LLC · Billings, MTBuilt 1981 · S/N 18504158 N59AKJaworski Roger W · Mesa, AZS/N 18503604 N59BMLissow William M · New Port Richey, FLBuilt 1959 · S/N 52120

Back to AD 87-20-03 R2