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.

N37GWillamette Valley Soaring Club · Beaverton, ORBuilt 1966 · S/N 188-0166 N37JSNewton Wm L · China Spring, TXBuilt 1959 · S/N 51915 N37LFWalter Cheri L · Hampshire, ILBuilt 1966 · S/N 17254460 N37LSKing Jay C · Vero Beach, FLBuilt 1973 · S/N P3370084 N37MJLara-Meza Sergio Giovanni · Mcallen, TXS/N P21000552 N37MMLeitch Mark W · Naples, FLBuilt 1966 · S/N 15062913 N37PB37pb Inc · Seattle, WABuilt 1972 · S/N 21059737 N37PPParsons Paul M · Aurora, COBuilt 1968 · S/N 15069944 N37RFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1977 · S/N 18503447 N37TJHodl Partners LLC · Allen, TXBuilt 1976 · S/N 18264795 N37WEagle Peak Links LLC · Cheyenne, WYBuilt 1970 · S/N 18260402 N37WTFaulk County Flying Club Inc · Faulkton, SDBuilt 1978 · S/N 17271385 N37ZQMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 15282684 N38009Harada Susan K · Salt Lake City, UTBuilt 1967 · S/N R172-0026 N3800DParker Bruce C · Boise, IDBuilt 1957 · S/N 34500 N3800SThompson Troy L · Limon, COBuilt 1963 · S/N 17251000 N3800USmith Dwight S · Ann Arbor, MIS/N 336-0100 N38014Friend Richard A · Pollock, IDS/N R172-0013 N3801DMann Lyle D · Summerville, ORBuilt 1957 · S/N 34501 N3801GWlds Investments LLC · Conway, ARBuilt 1967 · S/N U206-0801 N3801JSchomberg Coby D · Washington, MOBuilt 1966 · S/N 15065101 N3801LSouth Mark B · Eastanollee, GAS/N 17253970 N3802DCorbitt Mindy J · Ocoee, FLBuilt 1957 · S/N 34502 N3802LHill Herman J · Corvallis, MTBuilt 1965 · S/N 17253971 N3802VBrink Gregory P · Joseph, ORS/N 18723 N3803DSaunders Clinton E · Belgrade, MTS/N 34503 N3803LHanna R Brian · Tallahassee, FLBuilt 1965 · S/N 17253972 N3803QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259903 N3803SReid Aviation LLC · Boise, IDBuilt 1963 · S/N 17251003 N3804DGabbert Lucious L · Prescott, AZBuilt 1957 · S/N 34504 N3804JBranagh Charles J · Clay, NYBuilt 1966 · S/N 15065104 N3804LAeroelite Solutions LLC · Kalispell, MTBuilt 1965 · S/N 17253973 N3804QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259904 N3804RVorhees Tyler R · Rockford, ILBuilt 1966 · S/N 17255304 N3804SSilvers Morris · Burnsville, NCS/N 17251004 N3804VIhlenfeldt Richard W · Forest Lake, MNBuilt 1948 · S/N 18662 N3804YChelmo Jed E · Kimball, SDBuilt 1964 · S/N 21058304 N3805DThurier Lawrence V · Stevens Point, WIBuilt 1957 · S/N 34505 N3805LVelasquez Veronica R · San Antonio, TXBuilt 1965 · S/N 17253974 N3805SWenk Mark J · Lakewood, PABuilt 1963 · S/N 17251005 N3805VN3805v LLC · Aubrey, TXBuilt 1948 · S/N 18663 N3805YMacys Flying Service Inc · Tulelake, CABuilt 1964 · S/N 21058305 N3806RMartin Gary J · Glasgow, MTBuilt 1966 · S/N 17255306 N3806VShirey Donnie W · Collinsville, OKBuilt 1977 · S/N R1722263 N3806YOnion Crest Air LLC · Arcadia, NEBuilt 1964 · S/N 21058306 N3808DByrd David P · King Salmon, AKBuilt 1957 · S/N 34508 N3808LGreensburg Jeanette Airport Administration · Jeannette, PAS/N 17253977 N3809DRhoads William · Williamsburg, VABuilt 1957 · S/N 34509 N3809LSale Reported · Oak Harbor, WASale reportedS/N 17253978 N3809RImhof Donald R · Central City, NEBuilt 1966 · S/N 17255309

Back to AD 87-20-03 R2