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.

N4124SAvondale Aviation LLC · Park Ridge, ILBuilt 1975 · S/N E-653N4124WGeaux Automotive Advertising LLC · La Place, LABuilt 2000 · S/N TH-1943N4125GSeeding Operations And Atmospheric Research (Soar) · San Angelo, TXBuilt 1977 · S/N 340A0297N4126SAv Advantage LLC · Birmingham, MIBuilt 1975 · S/N TC-1848N4127QHurd Aviation LLC · Lexington, KYBuilt 1967 · S/N 310N-0027N4127SKrall Jeff P · Mitchell, SDBuilt 1975 · S/N D-9738N4128UMiles David Trevor · Colfax, CABuilt 1999 · S/N 3449100N4129APrillaman Leeland V · Martinsville, VABuilt 1970 · S/N CD-1242N412AABagdasarian Walter DBA · El Cajon, CABuilt 2006 · S/N 41627N412AGAme Aviation LLC · Denver, COBuilt 2021 · S/N 2331N412AVMatthews Air LLC · Powhatan, VABuilt 2015 · S/N E-4073N412BPMission Hardward Ltd Co · Savannah, GABuilt 1983 · S/N T30300213N412BSN412bs LLC · Southport, CTBuilt 2016 · S/N 1258N412CAAirswiss Inc · Wilmington, DES/N 402C0005N412CGBlue Sky Naples LLC · Naples, FLBuilt 2015 · S/N 0992N412CKAir Blair LLC · Hubbard, OHBuilt 2019 · S/N 1900N412CPSevern Aviation LLC · Richmond, VABuilt 2009 · S/N 3457N412CRRegistered aircraftBuilt 2024 · S/N 9940N412DPickens Ray T · Pleasanton, TXBuilt 1974 · S/N TH-464N412DGJannelli Gilbert DBA · Clearwater, FLS/N 35690N412DJStringfield Lisa P · Los Alamos, NMBuilt 2005 · S/N 1433N412GHHavemeier Gregory Wiliam · Marco Island, FLBuilt 2019 · S/N TH2518N412JJSkybird Aviation LLC · Bowling Green, KYBuilt 2007 · S/N 2846N412JLBills Brian J · Corry, PABuilt 1966 · S/N TE-38N412MFCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11660N412MMChen Kevin · San Antonio, TXBuilt 2003 · S/N 1285N412MSLfg Aviation LLC · Crossville, TNBuilt 2021 · S/N 2292N412PABulletproof Asset Holdings LLC · Bradenton, FLBuilt 2023 · S/N 9078N412PGVisual Approach LLC · Vienna, VABuilt 2026 · S/N 11276N412PRColumbia N333xc LLC · Lewes, DEBuilt 2007 · S/N 41787N412RPHopkins Henlopen Homestead LLC · Lewes, DEBuilt 2006 · S/N 41673N412SJRegistration Pending · La Place, LARegistration pendingS/N 310-0037N412SRHealing Waters Counseling Center LLC · Cedar Bluff, VABuilt 2006 · S/N 2176N412TRoberts Gregory · Scottsdale, AZBuilt 1972 · S/N 21059558N412TKBaerresen Drake A · Corona, CAS/N 0552N412WDColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2025 · S/N 10948N412YMurrieta Humberto · San Antonio, TXS/N D-9292N412YZLegacy Air Group LLC · Palm City, FLBuilt 2023 · S/N 9089N4130SYakish S Dale · Wexford, PABuilt 1975 · S/N TH-612N4130TSteven J Leavitt · Avondale, AZS/N 320D0030N4132QKarlen John R IV · Edwards, CABuilt 1967 · S/N 310N-0032N4133BMachinerywatch.Com Inc · Louisa, VABuilt 1975 · S/N 75-30795N4133QGaston Prentice W Jr · Carmel, INBuilt 1967 · S/N 310N-0033N4133YBlain Gerhart · Billings, MTS/N 18052828N4134SQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N TJ-18N4135BBice Christopher S · Summerville, SCS/N 76-30808N4135SRazzyfish Inc · Colton, CABuilt 1975 · S/N D-9787N4135TNehls Chevrolet Olds Cadillac · Marshall, TXBuilt 1965 · S/N 320D0035N4135ZSsk Ventures LLC · Eagle, COBuilt 1999 · S/N 3449134N41362Bird Dog N41362 LLC · Midland, TXBuilt 1951 · S/N 22587
Back to AD 2000-23-21