OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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

N451RKHeine John C · Santa Barbara, CABuilt 2015 · S/N 1153N451STrevathan Max Tyler · Dyersburg, TNBuilt 1977 · S/N E1200N451SBModleski Matthew · Noblesville, INBuilt 1978 · S/N TH-897N451SGNolt Air LLC · Lititz, PABuilt 2018 · S/N 1789N451SRSkywalk LLC · Olive Branch, MSBuilt 2007 · S/N 2325N451SWAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1960 · S/N 50885N451TJSr22 Aviators LLC · Crete, ILBuilt 2004 · S/N 0866N451USGreen Llp · Newport Beach, CABuilt 2006 · S/N 29-0437N451VLSo Fly Aviation LLC · Eugene, ORBuilt 2026 · S/N 11370N4520FRegistered aircraftBuilt 1966 · S/N 185-1005N4521BWitthaus James K Jr · Anchorage, AKBuilt 1955 · S/N 31420N4522KGoodman Jack A · Memphis, TNBuilt 1979 · S/N P21000209N4522SSpecialty Surgery Centers Of America Inc · Brentwood, TNBuilt 1975 · S/N TC-1889N4523SLucky92 & Associates LLC · Reno, NVBuilt 1976 · S/N TE-1062N4524SKnox James P · Park Rapids, MNBuilt 1975 · S/N E-727N4527BKrogman Aerial Spraying Inc · Lake Lillian, MNBuilt 1955 · S/N 31426N4527MF33 Air LLC · Selinsgrove, PABuilt 1978 · S/N CE-768N4528BHayton James B · Sedro Woolley, WABuilt 1955 · S/N 31427N4528JRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1980 · S/N T18803744TN4528SMoore William W · Merritt Island, FLBuilt 1975 · S/N D-9799N4529MMetzler Aaron · Otis, COBuilt 1978 · S/N D-10115N4529SRegistration Pending · Frisco, TXRegistration pendingBuilt 1975 · S/N CE-600N452CWashington Derrick A · Louisville, KYBuilt 1999 · S/N E-3256N452CDTimber Ridge Aviation LLC · Wilmington, DEBuilt 2010 · S/N 3652N452FRBonanza Valley LLC · Reno, NVBuilt 2012 · S/N E-3976N452JGQualitair LLC Trustee · MichelstadtS/N 1415N452JSOffroad Aviation LLC · Las Vegas, NVBuilt 1963 · S/N 18255172N452MDHeartsill Lucas G · San Angelo, TXBuilt 2016 · S/N 4426N452PSScuffletown LLC · Highlands, NJBuilt 2006 · S/N 29-0454N452SCBond Jeffrey B · Lebanon, MOBuilt 1975 · S/N D-9771N452SKAlcock Shane Vincent · Temple, TXBuilt 1972 · S/N 73-30522N452THHumphrey Andrew D · Johnstown, OHS/N 8-4949N452TTCharney Howard S · Genoa, NVBuilt 2022 · S/N 8751N452TXEfficient Transportation Services LLC · Harpers Ferry, WVBuilt 2015 · S/N 4233N452VABegio Aviation LLC · Arlington, VABuilt 2019 · S/N 4776N4530BMichael Anna B · Daytona Beach, FLBuilt 1955 · S/N 31429N4530FBean David L · Chandler, AZBuilt 1966 · S/N 185-1015N4532SElite Aviation Partners LLC · Blacklick, OHBuilt 1975 · S/N CE-598N4533BHastie William B · Anchorage, AKBuilt 1955 · S/N 31432N4533JStevens Investment Group LLC · Elsie, MIBuilt 1980 · S/N T18803745TN4533SBolanos Nilson J · Fairview, NJBuilt 1975 · S/N CE-612N4534BHornung Chet R · Nikiski, AKBuilt 1955 · S/N 31433N4534FSmith Peter A · Gunnison, COBuilt 1966 · S/N 185-1019N4534MFowler Bruce Jr · Cedar Park, TXBuilt 1956 · S/N 58-11088 (FM88)N4534SMarmon Robert A · Merion Station, PABuilt 1975 · S/N E-743N4535FRohde Allen G · Eagle River, AKBuilt 1966 · S/N 185-1021N4536KGowharrizi Ardeshir G · Los Angeles, CABuilt 1948 · S/N NAV-4-1536N4537BNewsom William A · Cheraw, SCBuilt 1955 · S/N 31436N4537MBullet Construction LLC · Roswell, NMBuilt 1979 · S/N TC-2234N4537QInstant Security Service Inc · Wilmington, DEBuilt 1972 · S/N 402B0343
Back to AD 2000-23-21