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.

N5144BCloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283774 N5144LEmpire Aviation · Oxford, NCBuilt 1980 · S/N 15284270 N5144NL-3 Communications Eo/Ir Inc · Loveland, COBuilt 1979 · S/N 18267543 N5144RBuffalo Flying Club Inc · Ayr, NDBuilt 1974 · S/N 17263361 N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851 N5145AMccullough Ronnie W · Golden, COBuilt 1955 · S/N 28145 N5145ESierra Pacific Aviation · Willits, CAS/N 17271735 N5145KZulu Jets LLC · Boerne, TXBuilt 1980 · S/N 17273986 N5145RSautner Steve · Anchorage, AKBuilt 1976 · S/N 18503008 N5146DAnderson Daniel S · Payson, AZS/N 51246 N5146QJ&G Aero Investments Group LLC · Wilmington, DEBuilt 1972 · S/N 21059646 N5146SBowden Mark R · Kansas City, MOBuilt 1980 · S/N R18201511 N5146VFischer John W · Waukesha, WIBuilt 1980 · S/N 172RG0455 N5146WN5146w LLC · Willow Spring, NCS/N P21000645 N51470Merryman Stephen R · Beach City, TXBuilt 1975 · S/N 17265816 N51472Breaks Bound LLC · Kalispell, MTBuilt 1966 · S/N 18256977 N5147EDirty Side Down LLC · Noblesville, INBuilt 1978 · S/N 17271737 N5147HBeyond Willpower Inc · Shreveport, LABuilt 1975 · S/N 17265349 N5147KCline Aircraft LLC · Mena, ARBuilt 1975 · S/N 17264522 N5147NMace Robert C Jr · Gold Canyon, AZS/N 17261417 N5147RKirkland Kerry G · Spring, TXBuilt 1974 · S/N 17263364 N5147UCox Coleman Haynie · Honea Path, SCBuilt 1980 · S/N 172RG0259 N5148ATurner Edward J III · Mokena, ILBuilt 1956 · S/N 28148 N5148DNick Peak Flying LLC · Mccall, IDBuilt 1958 · S/N 51248 N5148EQuandary Consulting Group LLC · Greenwood Village, COBuilt 1959 · S/N 50448 N5148FBonura Rocco F Jr · Perkinston, MSBuilt 1964 · S/N 17252980 N5148HMalad Aviation LLC · Bliss, IDBuilt 1975 · S/N 17265350 N5148JTc Cavu Club LLC · Traverse City, MIS/N 17273715 N5148KHetteen David D · Camano Island, WABuilt 1980 · S/N 17273988 N5149EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271738 N5149R5149r LLC · Manhattan, MTBuilt 1974 · S/N 17263366 N514DPPitts Donald W · Sand Springs, OKBuilt 1960 · S/N 52546 N514GCCristan Gene V · Lake Mary, FLBuilt 1956 · S/N 33356 N514KKSchaperkotter Harold M Jr · Anchorage, AKBuilt 1960 · S/N 50796 N514MDPerez Pedro J · Mayaguez, PRBuilt 1975 · S/N 17266476 N514RBOsprey Holding Company LLC · Foley, ALS/N 17265552 N514TPactolus Investments LLC · Blounts Creek, NCBuilt 1980 · S/N U20605940 N514TCChildress Anthony H · Frisco, TXBuilt 1973 · S/N 17701995 N514TDDay William B · Conroe, TXBuilt 1979 · S/N 18267361 N5150DTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272435 N5150UMolina Monreal Angel Humberto · Sahuarita, AZS/N 172RG0261 N51515Wolfe Douglas S · Yucaipa, CABuilt 1980 · S/N 17274316 N5151BTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 15283778 N5151EBlhh · Dixon, CABuilt 1982 · S/N 18268293 N5151LTownsend Richard · Barrington, NHBuilt 1980 · S/N 15284273 N5151QNotsa LLC · Morrison, COBuilt 1972 · S/N 21059651 N5151RLuszczek Christopher L · Berkshire, NYBuilt 1974 · S/N 17263368 N51526My Way Aviation LLC · Weston, FLS/N 17274317 N5152ASaunders George A Jr · Powhatan, VABuilt 1955 · S/N 28152 N5152QB & L Property Holdings LLC · Brush Prairie, WABuilt 1973 · S/N 17261766

Back to AD 87-20-03 R2