OpenAirDocs.org
AD 75-23-08 R5

Registered aircraft · 999

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

N440DL421 Partners LLC · Crown Point, INBuilt 1983 · S/N 421C1401N440JBAg Tech Farm Services · Gamaliel, KYBuilt 1975 · S/N 421B0858N440LJByington William · Minden, NVS/N 421C0299N4440KKate & Jennifer Airlines LLC · Tampa, FLBuilt 1974 · S/N 421B0567N444ATCore Aviation LLC · Dayton, OHS/N 421B0897N444BGMitchell Aviation LLC · Mitchell, SDBuilt 1980 · S/N 421C0893N444HDChado Richard P II · Rancho Cucamonga, CAS/N 421C0480N444HTTaktos Ltd · Corvallis, ORBuilt 1973 · S/N 310Q0739N444SMPosada Law Pllc · Boca Raton, FLBuilt 1974 · S/N 421B0814N444TAMiller Conner · Lake Havasu City, AZBuilt 1973 · S/N 421B0390N4492UAircraft & Aviation Professionals LLC · Coldwater, MIS/N 421C0020N44DPD L S Aviation Inc · Wilmington, DEBuilt 1968 · S/N 310P0039N44KFEbert Construction Co Inc · Wamego, KSBuilt 1974 · S/N 421B0598N44SCAir Charter Solutions Inc · Bloomington, MNBuilt 1969 · S/N 421A0101N451AMPalm Tree Adventures LLC · Austin, TXS/N 421C0808N4537QInstant Security Service Inc · Wilmington, DEBuilt 1972 · S/N 402B0343N4550QIsland Wings Inc · Fort Lauderdale, FLBuilt 1969 · S/N 402A0050N455XTreat-Yo-Self Confections Inc · Corona, CABuilt 1973 · S/N 310Q1007N456HACeltic Air Inc · Lake City, FLBuilt 1974 · S/N 421B0614N458VCWing And A Prayer LLC · Sarasota, FLBuilt 1974 · S/N 421B0915N459DMStafford Wings LLC · Fredericksburg, VABuilt 1981 · S/N 421C1084N45BBSpeer Aircraft LLC · Evansville, INBuilt 1979 · S/N 421C0661N45JRJmf Inc · St Maries, IDBuilt 1976 · S/N 421C0109N464DCDelta Charlie Aviation LLC · Glendale, AZBuilt 1979 · S/N 421C0709N465DLKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 310R1622N466JWWf Construction Inc · La Verne, CAS/N 421C0241N466PJv Aviation LLC · Johnston, RIBuilt 1977 · S/N 310R0988N467DMMustang Sally Aviation LLC · Camden, SCBuilt 1973 · S/N 421B0377N469CJHerndon Aviation LLC · Kokomo, INBuilt 1980 · S/N 421C1018N469LCGaletti Ralph R · Albuquerque, NMBuilt 1974 · S/N 421B0627N471BWPatriot Environmental LLC · Meeker, OKS/N 421C0640N477MGJuliet Delta Aviation LLC · Bozeman, MTBuilt 1973 · S/N 421B0477N47JDQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 421C0805N47SPDurham Rex L · Blakely, GABuilt 1969 · S/N 310P0176N483MMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1977 · S/N 421C0314N485CBBlue Pathways LLC · Statesville, NCS/N 421C0466N485DSEncinal Aviation LLC · Springfield, MOBuilt 1978 · S/N 421C0459N488DMAircraft One Ltd · Grand Rapids, MIS/N 421C-0485N488KRedcell Air Inc · Miami, FLBuilt 1976 · S/N 421C0078N48BPRossman Richard J DBA · Glenview, ILBuilt 1975 · S/N 421B0957N48CPDouglas Aviation Ltd · South Barrington, ILS/N 421C0902N4937JSwirsding David J · Chalfont, PABuilt 1977 · S/N 310R0952N493JHBrooklyn LLC · Parker, COS/N 421C0860N4948AKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1410N4949ASw Air LLC · Denver, COS/N 310R1505N49ARMoore Thomas A · Kennewick, WAS/N 421B0563N4ADValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 421B0467N4GKDalessandro Janet E · Park Falls, WIBuilt 1975 · S/N 310R0219N4MUBlusky Properties & Investments LLC · Cameron, MOBuilt 1970 · S/N 421B0054N4MZBank Of Utah Trustee · Salt Lake City, UTS/N 421C0829
Back to AD 75-23-08 R5