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.

N8HTServicetec LLC · Kalamazoo, MIBuilt 1978 · S/N 421C0618N8WBSmartin Enterprises LLC · Clackamas, ORBuilt 1974 · S/N 421B0594N900CBHnl Group LLC · Minnetonka, MNS/N 421C0837N900GMKashtan David L · Mill Valley, CABuilt 1977 · S/N 310R1249N903JDAirventure LLC · Fort Lauderdale, FLS/N 421C0420N904BCFox 3 Partners LLC · Virginia Beach, VABuilt 1981 · S/N 421C1027N9063MThompson Anthony · Miami, FLBuilt 1971 · S/N 402B-0105N90MKBs LLC · Huntsville, TXBuilt 1977 · S/N 421C0282N910MFly By Night Aviation LLC · San Francisco, CABuilt 1979 · S/N 310R1653N915LPLee Flight Services LLC · Davie, FLS/N 421B0572N916MD43701 Corp · Zanesville, OHBuilt 1981 · S/N 310R2133N918BVDietz John W Jr · Westfield, INBuilt 1982 · S/N 421C1247N921AJAerohippo Corp · Franklin Lakes, NJBuilt 1974 · S/N 421B0613N925BKAcom Electronic Measurement Technology Inc · Milpitas, CABuilt 1976 · S/N 0117N926MTNew London Aviation LLC · Forest, VABuilt 1978 · S/N 421C0625N928DMEllis Leven Handy IV Trustee · Champions Gate, FLS/N 421B0835N92903Nalle W B · Austin, TXBuilt 1981 · S/N 310R2140N92CVRandall Grier Ministries · Owasso, OKBuilt 1984 · S/N 421C1065N92DFN92df Slo LLC · Arroyo Grande, CAS/N 421C0889N92PSMeshoppen Air LLC · Tunkhannock, PABuilt 1971 · S/N 421B0134N934JDCitation Time LLC · Seguin, TXS/N 310R1002N936AFVasquez Ahyde E · Brownsville, TXS/N 421C0606N942SWVascoe Jeffre M · Houston, TXBuilt 1981 · S/N 421C1025N945BGDavis James H · Corpus Christi, TXBuilt 1980 · S/N 421C-0870N9469CKinetic Concepts LLC · Pensacola, FLS/N 310R1419N954MCBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 421B0891N95GMMeinig High Club LLC · Klamath Falls, ORBuilt 1980 · S/N 421C0821N960EMCowboy Up Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 421B0881N969THMgi Proflight LLC · Las Vegas, NVBuilt 1978 · S/N 310R1379N974CFAviation Trust Company LLC · Oklahoma City, OKBuilt 1974 · S/N 421B0609N977BHMotors Inc · Cumming, GAS/N 421C0227N977SMKmc Aviation Leasing LLC · Indianapolis, INBuilt 1974 · S/N 421B0595N97DHEmbry Aero Ltd · Greenville, ILBuilt 1978 · S/N 421C0450N97HCAlpha Whiskey 1 LLC · Brandon, MSBuilt 1976 · S/N 310R0651N98437Infranco Anthony · Amityville, NYBuilt 1975 · S/N 421C0040N984DSWilger Thomas J · Lafayette, COS/N 310R0622N98649Dodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 402B1030N98697Gimli Son LLC · Fort Lauderdale, FLS/N 402B1053N987MCTwa LLC · Weatherford, OKBuilt 1977 · S/N 421C0439N98869Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0625N994MZMahz Air LLC · Laredo, TXBuilt 1985 · S/N 421C1803N998JA2 Doods LLC · Lakewood Ranch, FLBuilt 1979 · S/N 310R0938N999DMJr605dc LLC · Amarillo, TXBuilt 1980 · S/N 421C0869N999WLLatshaw Training Group Inc · Vero Beach, FLS/N 421C0320N99VK421 Golden Eagle LLC · Cheyenne, WYBuilt 1969 · S/N 421A0091N9AYProclaim Aviation Ministries · Worthington, MNBuilt 1980 · S/N 421C0844N9RVPotter Steven R · Grapevine, TXS/N 310Q0234N9RZChapman Inc · Sherman, TXS/N 421C0236N9SDResort Aviation LLC · Surfside Beach, SCS/N 421B0888
Back to AD 75-23-08 R5