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.

N5906ROlson Bradley P · Pendleton, ORBuilt 1965 · S/N 17253575 N5906TGraf John R · Mather, CABuilt 1964 · S/N 15060606 N59073Hartenstine Michael Carl · Lancaster, CABuilt 1973 · S/N 21060069 N5907BWarner Aric D · Rosamond, CAS/N 33907 N5907ERiver City Flying Club Inc · Valley Center, KSBuilt 1978 · S/N 17271957 N5907FIsland City Seaplanes Inc · Cordova, AKBuilt 1967 · S/N 21058907 N5907RBrown Kriss · Naperville, ILBuilt 1965 · S/N 17253576 N5907TMccracken David M · Woodland, PABuilt 1964 · S/N 15060607 N5908APomeroy Cattle Ranch LLC · Kalispell, MTS/N 28508 N5908BLifland Kenneth D · Mckinney, TXBuilt 1956 · S/N 33908 N5908FCharger Aviation LLC · Chariton, IABuilt 1967 · S/N 21058908 N5908GRohrbough Nathan F · Weston, WVBuilt 1969 · S/N 15071408 N5908TDorweiler Tom O · Springfield, MOBuilt 1964 · S/N 15060608 N5909ARyan Michael W · Rincon, GABuilt 1956 · S/N 28509 N5909EOwens Flight Training LLC · Lafayette, LABuilt 1978 · S/N 17271958 N5909FHendrix Benton · Eckley, COBuilt 1967 · S/N 21058909 N5909RWagner Christopher J · Tulsa, OKBuilt 1965 · S/N 17253578 N590SProspect Ridge Aviaton Inc · Morganton, NCBuilt 1981 · S/N 172RG0818 N59105Allen Willis M Jr · El Cajon, CABuilt 1973 · S/N 21060093 N5910AAlumbaugh Ian M · Mcpherson, KSBuilt 1956 · S/N 28510 N5911BKatzer Jamin · Frederick, COBuilt 1956 · S/N 33911 N5911JAveightor LLC · Alba, TXBuilt 1975 · S/N 18263574 N5912BPrice Rand S · Casper, WYBuilt 1956 · S/N 33912 N5913GFerguson Joe C · Shreveport, LABuilt 1969 · S/N 15071413 N5913RWilliams Alonzo · Bentonville, ARBuilt 1965 · S/N 17253582 N59141Peters Mark E · Newport News, VABuilt 1973 · S/N 21060118 N59146Universal Charter Service Inc · Auburn, CABuilt 1974 · S/N U20602624 N5914BStrong Brian DBA · Southport, NCBuilt 1956 · S/N 33914 N5914JFreedom One Inc · San Jose, CABuilt 1975 · S/N 18263575 N5914RWaldrop Charles Trustee · Oklahoma City, OKBuilt 1965 · S/N 17253583 N5915AMyers Glen L · Grassy Butte, NDBuilt 1956 · S/N 28515 N5915BTaylor Scott G · Draper, UTBuilt 1956 · S/N 33915 N5915FJeffries Phillip L · Belington, WVBuilt 1967 · S/N 21058915 N59164Marine Electrical & Refrigeration Of Kodiak LLC · Kodiak, AKBuilt 1974 · S/N U20602626 N5916FTlc Flying Inc · Colfax, WABuilt 1967 · S/N 21058916 N5916JUnited States Air Force - Owner · Eglin Afb, FLBuilt 1980 · S/N 17273845 N59173Vogelgesang Randy · Gardnerville, NVBuilt 1973 · S/N 21060141 N59175Brown Charles A · Boise, IDBuilt 1959 · S/N 55932 N5917BHauser Nathan S · Newark, DEBuilt 1956 · S/N 33917 N5917RParcell Evelyn Cassandra · Norfolk, VAS/N 17253586 N59180Kennedy Jared W · Cordova, AKBuilt 1980 · S/N 50582 N59181Meader Luke C · Marfa, TXBuilt 1959 · S/N 52085 N59182Abbott James H · Gallatin, TNBuilt 1958 · S/N 51578 N5918JStansfield Carl B · Springdale, UTS/N A1500218 N5918T2400 Rickenbacker LLC · Auburn, CABuilt 1964 · S/N 15060618 N5919AFederico Gilbert · Litchfield Park, AZBuilt 1956 · S/N 28519 N5919BBell Ian E · Rapid City, SDBuilt 1956 · S/N 33919 N5919JFiles Richard W · Yuma, AZBuilt 1970 · S/N A1500219 N591NCPotto Aviation Inc · Wilmington, DEBuilt 1981 · S/N 18053193 N5920A20 Awesome LLC · Albuquerque, NMBuilt 1956 · S/N 28520

Back to AD 87-20-03 R2