OpenAirDocs.org
AD 82-23-01 R1

Registered aircraft · 3,118

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
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:82-23-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-23-01-R1')
  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.

N87878International Air Services Inc Trustee · Carson City, NVBuilt 1959 · S/N 24-469N8787PA B Helton Enterprises LLC · Warthen, GABuilt 1965 · S/N 24-4239N8788YAerotransit Inc · Milwaukee, WIS/N 30-1946N8789PCannell John D · New Franken, WIBuilt 1965 · S/N 24-4241N8790PBison Reserved LLC · Chicago, ILBuilt 1965 · S/N 24-4243N8791YGeboy Alan R III · Baxley, GABuilt 1969 · S/N 30-1949N8792PPrivette Richard E · Oak Hill, FLBuilt 1965 · S/N 24-4245N8793PFlaagan Kevin D · Beulah, NDBuilt 1965 · S/N 24-4246N8794PDelaware Mark P · Phoenix, AZBuilt 1965 · S/N 24-4247N8795PJejgr LLC · Presho, SDBuilt 1965 · S/N 24-4248N8795YJohnson Paul · Wichita Falls, TXS/N 30-1954N8796PAllie Doug B · Glasgow, MTBuilt 1965 · S/N 24-4249N8797PPlant Curtis W · Runge, TXBuilt 1965 · S/N 24-4250N8797YHight Derrick R · North Aurora, ILBuilt 1969 · S/N 30-1812N8799PMontgomery M Kim · Vega, TXBuilt 1965 · S/N 24-4252N87CWZou Christian · Chandler, AZBuilt 1967 · S/N 30-1639N87RPWhitehead Glenn K · Friendswood, TXS/N 24-1603N8800PAnp Networks Corp · Las Vegas, NVS/N 24-4253N8800YAlexander City Aviation Corp · Alexander City, ALBuilt 1969 · S/N 30-1956N8802PPennington Mitchell T · Medley, WVBuilt 1965 · S/N 24-4257N8803PWade Brian K · Apalachin, NYBuilt 1965 · S/N 24-4258N8804YMartino Aviation LLC · Wilmington, DES/N 30-1960N8806PZiolkowski James E · Amarillo, TXBuilt 1965 · S/N 24-4261N8807PRegistered aircraftBuilt 1965 · S/N 24-4263N8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 30-1964N8808YAukes Brian E · Huxley, IABuilt 1969 · S/N 30-1965N8809PPa24 LLC · Painesville, OHBuilt 1965 · S/N 24-4265N8811YHutchinson Douglas E · Cle Elum, WABuilt 1969 · S/N 30-1968N8812PRegistered aircraftBuilt 1965 · S/N 24-4267N8812YSpain Air LLC · Dadeville, ALBuilt 1969 · S/N 30-1969N8813PWolcott Kent E · Colorado Springs, COBuilt 1965 · S/N 24-4268N8814YTwin C 14y LLC · Cape Coral, FLBuilt 1969 · S/N 30-1972N8815YBauer Andrew J · Concord, NCBuilt 1969 · S/N 30-1973N8817PTei Corp · Kalispell, MTBuilt 1965 · S/N 24-4273N8817YWiehl Thomas K III · Earlysville, VABuilt 1969 · S/N 30-1975N8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 30-1976N8819PN8819p LLC · Boca Raton, FLBuilt 1965 · S/N 24-4275N8822PCornwell Charles E · Tucson, AZBuilt 1965 · S/N 24-4278N8823YFerrara John M · Newtown, PABuilt 1969 · S/N 30-1981N8824PAzimi Matthew H · Navarre, FLBuilt 1965 · S/N 24-4280N8826PIngalls Equipment LLC · Redlands, CABuilt 1965 · S/N 24-4282N8829PInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 24-4285N8830PCanon Daniel H · Fruit Cove, FLBuilt 1965 · S/N 24-4286N8832PRoundtree Benjamin · Cass City, MIBuilt 1965 · S/N 24-4288N8833PRegistered aircraftBuilt 1965 · S/N 24-4289N8833YGagan Samrat LLC · Charlotte, NCBuilt 1969 · S/N 30-1991N8835PFeller James P · Granite Bay, CABuilt 1965 · S/N 24-4291N8836YLodge Aviation LLC · Lewes, DEBuilt 1969 · S/N 30-1994N8837YWilfly Inc · Dahlgren, ILBuilt 1969 · S/N 30-1995N8838PLogan Flyers LLC · Logan, OHBuilt 1965 · S/N 24-4293
Back to AD 82-23-01 R1