OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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.

N1BFRussell Kellum LLC · Saratoga, CABuilt 1973 · S/N TE-961N1BPPatton Ministries · Grand Rapids, MNBuilt 1961 · S/N 18253260N1CJSandy Air LLC · Austin, TXBuilt 2019 · S/N 1941N1CKWilson Nick · Glenwood, ILBuilt 1966 · S/N CE-30N1CNNothing By Chance LLC · Jackson, WYBuilt 1967 · S/N TE-313N1CSMoseley Ailsa · Wellington, FLBuilt 1946 · S/N NAV-4-106N1CTTre Aviation Corp · Queen Creek, AZBuilt 1972 · S/N P3370001N1DJOwyhee Air LLC · Murphy, IDBuilt 1987 · S/N CE-1116N1DZXtreme Flying Services LLC · Gansevoort, NYBuilt 1961 · S/N 18253742N1EVGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1979 · S/N E-1463N1EWNelson Patrick A · Winston, GABuilt 1962 · S/N NAV-4-2480N1EZLexthistle Enterprises LLC · Sunset, LABuilt 2007 · S/N L2K-426N1FHBuermann Henry · Brookfield, VTS/N 18052817N1FXTl Consulting LLC · Cadiz, KYBuilt 1963 · S/N TC-406N1HBRye-Corp LLC · Lenoir City, TNBuilt 1968 · S/N TC-1069N1HUCaster-Way LLC · Sebring, FLBuilt 1968 · S/N 337-1008N1JJChrapczynski Daniel T · Sheffield Village, OHBuilt 1972 · S/N 30461N1JYRicks Electric Plus LLC · Middleton, IDBuilt 1958 · S/N 51474N1KPSherman Loren R Jr · Granbury, TXBuilt 1973 · S/N 21060006N1KVParagon Aviation LLC · Greenland, NHFirst renewal noticeBuilt 2003 · S/N 40063N1KYCatherines Aviation Services LLC · Sewanee, TNBuilt 1968 · S/N CJ-3N1LVMcarthur Thomas M · Annapolis, MDBuilt 1966 · S/N CE15N1LXDix Justin T · South Boston, VABuilt 1973 · S/N E-419N1MFWise Christopher J · Plano, TXS/N TH-835N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731N1NMShaffer Thomas F DBA · Somerset, PAS/N D-5211N1PHRegistered aircraftBuilt 1983 · S/N CE-1018N1PLMtma Consulting LLC · Emerald Isle, NCBuilt 2018 · S/N 1687N1PZRegistered aircraftBuilt 1972 · S/N TE-890N1QPN667sr LLC · Richmond, KYBuilt 1972 · S/N 18261605N1QYJet X Leasing Inc · Johnson, KSBuilt 1964 · S/N CD-798N1RMMeggers Roger D · Baker, MTBuilt 1975 · S/N 18502686N1RTFrost Darrell G · Atlanta, TXBuilt 1966 · S/N TE-185N1SBHattan John A · Goddard, KSBuilt 1974 · S/N 18502377N1SJRegistered aircraftBuilt 2017 · S/N 4493N1SKWienhoff Kevin Bruce · Salem, ORS/N D-9339N1TZHundredaire LLC · Wichita, KSBuilt 2008 · S/N E-3830N1UFGrand Aviation Inc · Grove, OKBuilt 1973 · S/N P3370098N1UHR N D Motorsports LLC · Duluth, MNBuilt 1994 · S/N 2227N1UZJet X Leasing Inc · Johnson, KSBuilt 1964 · S/N D-7420N1VZKilian Michael S · Morrow, OHBuilt 1979 · S/N E-1491N1WDBushcraft Aviation LLC · Cypress, TXBuilt 1961 · S/N TC-192N1WFRegistered aircraftBuilt 1968 · S/N D-8880N1WXRegistered aircraftBuilt 2022 · S/N E-4148N1YCMay Thomas W · Texarkana, TXBuilt 1976 · S/N 310R0621N1YDBerg Bradley · Tulare, CABuilt 1968 · S/N 21059105N1YRPerley Kevin G Trustee · Sioux City, IABuilt 1975 · S/N D-9797N1YTOne Yankee Tango LLC · Jenks, OKBuilt 1978 · S/N 18266473N1ZMNazari Nowzar · Rancho Cucamonga, CAS/N P3370200N1ZPConcord Flying Club Inc · Lafayette, CAFirst renewal noticeBuilt 1971 · S/N E-262
Back to AD 2000-23-21