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.

N6533FMoore William H III · Deer Park, WABuilt 1966 · S/N 15063133 N6534FAnderson Ted E · Petal, MSBuilt 1966 · S/N 15063134 N6534LAndreassen Andrew R · Pleasanton, NEBuilt 1980 · S/N 15284428 N6534MJcj Aero LLC · Star, IDBuilt 1975 · S/N 18263743 N6534NDoxsee Joshua · Beverly, MABuilt 1978 · S/N 21063090 N6535GBbjs Investments LLC · Burlington, WIBuilt 1979 · S/N 17273606 N6535MLodwick Kristopher O · Steamboat Springs, COBuilt 1975 · S/N 18263744 N6535S315 Flight Club LLC · Fulton, NYBuilt 1967 · S/N 15067335 N6535VEllenberg Sholom · Weston, CTBuilt 1981 · S/N 172RG0731 N6535YRichardson Jane S · San Angelo, TXS/N 21064424 N6536GMessersmith Brian W · Grand Prairie, TXS/N 15072036 N6536HThree Rivers Lake Creek LLC · Kapolei, HIS/N 18503332 N6536MSmith Brian L · Lake Oswego, ORBuilt 1975 · S/N 18263745 N6536PWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285029 N6536SSohr Brian S · Oconto, WIBuilt 1967 · S/N 15067336 N6536VTran Dai A · Rancho Cucamonga, CABuilt 1980 · S/N 172RG0760 N6537DCunningham Edward A · Washington, DCBuilt 1979 · S/N 17272853 N6537EDittmer Michael C · Springtown, TXS/N 56037 N6537FWheels Up Aviation LLC · Pittsburgh, PABuilt 1979 · S/N 17273236 N6537GShettel Jay E · Boiling Springs, PAS/N 15072037 N6537HRivers Robert A · Oxford, NCBuilt 1975 · S/N 17265480 N6537WSilver Eagle Holdings LLC · Jerome, IDS/N P21000793 N6538FMbk Leasing And Consulting LLC · Lakeland, FLBuilt 1979 · S/N 17273237 N6538NHaynie Ray G · Auburn, WABuilt 1978 · S/N 21063094 N6538VSommer Timothy T · Combined Locks, WIBuilt 1980 · S/N 172RG0762 N6538XRegistration Pending · Fallon, NVRegistration pendingBuilt 1960 · S/N 57538 N65398Seeley Timothy C Trustee · Chico, CABuilt 1978 · S/N 15281526 N6539FSweitzer Merle E · Felton, PABuilt 1966 · S/N 15063139 N6539GSchneider Joel · Champaign, ILBuilt 1970 · S/N 15072039 N6539HAbove The Haze LLC · San Lorenzo, CAS/N 17265481 N653SRVertex Aviation Services LLC · Burlington, WABuilt 1968 · S/N 17701048 N65401Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281529 N65407Clemson Flying Club Inc · Seneca, SCS/N 15281533 N65408Hendrix Aviation Inc · Plantation, FLBuilt 1978 · S/N 15281534 N6540AEyler Stuart L · Oceanside, CABuilt 1956 · S/N 32437 N6540EAerial Crop Care Co · Hebron, NDBuilt 1959 · S/N 56040 N6540GKultti Richard O · Sonoma, CABuilt 1970 · S/N 15072040 N6540SHalverson Jan T · Goldendale, WABuilt 1967 · S/N 15067340 N65415Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15281537 N65417Frear Robert · N Redngtn Bch, FLBuilt 1978 · S/N 15281539 N6541EAkers Sean M · East Wenatchee, WAS/N 56041 N6541MAero Adventures Of Ms LLC · Hazlehurst, MSBuilt 1975 · S/N 18263747 N6541SBurke Frank E Jr · Scotland, SDBuilt 1967 · S/N 15067341 N6542CLeonard Summers · Pleasanton, CABuilt 1980 · S/N 21063913 N6542EBond Ward Thomas · Salem, MOBuilt 1959 · S/N 56042 N6542HOwens Flight Training LLC · Lafayette, LABuilt 1975 · S/N 17265482 N6542NHill Jonathan G · Dover, NHBuilt 1978 · S/N 21063098 N6542UMcdade John P · Fraser, COBuilt 1985 · S/N 21064957 N6542VHarris Dakota · Goose Creek, SCBuilt 1980 · S/N 172RG0765 N65435Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281550

Back to AD 87-20-03 R2