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.

N31LDGustte Phil · North Fort Myers, FLBuilt 1973 · S/N 17262736 N31MDKarmy Paul Edward · Burleson, TXBuilt 1980 · S/N P21000595 N31MRAllred Don J · Wellington, TXBuilt 1974 · S/N 18262907 N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693 N31SRIsaac Timothy S · Independence, ORBuilt 1962 · S/N 18051098 N31VRGlaze Roy J · Smyrna, TNBuilt 1976 · S/N 33701731 N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291 N31YBProgressive Air Inc · Janesville, WIBuilt 1979 · S/N 18266786 N31ZWestern Skymasters LLC · Salt Lake City, UTBuilt 1973 · S/N P3370028 N3200CRegistered aircraftBuilt 1953 · S/N 25833 N3200ERegistration Pending · Burlington, WIRegistration pendingBuilt 1978 · S/N 17271466 N3200JOdell Steven P · Perrysburg, OHBuilt 1966 · S/N 15065900 N3200SGreene James · Georgetown, TXBuilt 1964 · S/N 18255700 N3200UAnderson & Assoc Attorneys At Law Pc · Virginia Beach, VABuilt 1962 · S/N 18254600 N3200YCondo Gerardo B · Miami, FLBuilt 1962 · S/N 18254200 N3201DMelnick Victor D · Mount Bethel, PABuilt 1955 · S/N 31999 N3201SBoder Eric T · Knoxville, TNBuilt 1964 · S/N 18255701 N3201XSale Reported · Glen Allen, VASale reportedBuilt 1966 · S/N 15064601 N3202CJohnson Jeremiah · Fairbanks, AKS/N 18262345 N3202LMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17256102 N3203ALowenstein Jeffrey · Juneau, AKBuilt 1953 · S/N 25847 N3203UKuykendall Kirk O · Lakeside, ORS/N 18254603 N3204DGriffith Sherman · Southlake, TXBuilt 1955 · S/N 32002 N3204JBecker Charles A · Rice Lake, WIBuilt 1966 · S/N 15065904 N3204UBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254604 N3204XKulesza Roman · Noblesville, INBuilt 1967 · S/N 15064604 N3205ARichards Peter C · Poughkeepsie, NYBuilt 1953 · S/N 25849 N3205DWest James · Monroe, MIS/N 32003 N3205UBanducci Debra L Trustee · Bakersfield, CABuilt 1963 · S/N 18254605 N3205XAvery Jackson R · Ontario, ORS/N 15064605 N3206DDenny Michelle L · Chugiak, AKBuilt 1955 · S/N 32004 N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467 N3206SHall David J · Red Bluff, CABuilt 1964 · S/N 18255706 N3207AMarin Jeremy V · Gardnerville, NVS/N 25851 N3207EArmstrong Aviation LLC · New Orleans, LABuilt 1978 · S/N 17271468 N3207SSouthern Star Aviation LLC · El Campo, TXBuilt 1964 · S/N 18255707 N3207UTaf Aerial Services LLC · Beeville, TXBuilt 1963 · S/N 18254607 N3208AKreitel Cody James · Anchorage, AKBuilt 1953 · S/N 25852 N3208JLandon Christopher L · Portland, ORBuilt 1966 · S/N 15065908 N3208SZirul James V · Kenai, AKBuilt 1964 · S/N 18255708 N3208UDiller Larry K · Fairview, MIBuilt 1963 · S/N 18254608 N3208XRhodenbaugh Mitchel D · Wyndmere, NDBuilt 1966 · S/N 15064608 N3208YHamilton Triple C Farms · Ririe, IDFirst renewal noticeBuilt 1962 · S/N 18254208 N320DDBronson Robert D Trustee · Prineville, ORBuilt 1972 · S/N 17261193 N3210PKilcullen Brian DBA · Fort Lauderdale, FLBuilt 1978 · S/N P21000027 N3210SGore Range Aviators LLC · Kremmling, COBuilt 1964 · S/N 18255710 N3210UHaas Todd · Pecatonica, ILBuilt 1963 · S/N 18254610 N3210YBergren William · Des Moines, IABuilt 1962 · S/N 18254210 N3211AFreeman Varel D · Ocala, FLBuilt 1953 · S/N 25855 N3211DNielson Donald L · Independence, ORBuilt 1955 · S/N 32009

Back to AD 87-20-03 R2