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.

N400BSMb Aviation Inc · Larue, TXS/N 421C1089N400CEMcmurray Bradley Thomas · Advance, NCBuilt 1975 · S/N 421B0930N400GMN400gm LLC · Salisbury, MDBuilt 1974 · S/N 310Q1000N400TMPaxton Homes LLC · Killeen, TXS/N 421B0885N402AJ2lyons Enterprises LLC · Wellington, FLBuilt 1975 · S/N 402B0884N402BFSnell Marion Lea · Ackerly, TXBuilt 1975 · S/N 402B1010N402CENorth American Aerial Surveys LLC · Tucson, AZBuilt 1973 · S/N 402B0364N402CZEmission-Air Inc · Welcome, NCBuilt 1972 · S/N 402B0213N402NKKhan Pervez · Miami Springs, FLBuilt 1972 · S/N 402B0314N402PAAir Flight Inc · Fort Lauderdale, FLBuilt 1973 · S/N 402B0329N402SSKellair Ltd Inc · Sunrise, FLNon-citizen corporation, flight hours not reportedBuilt 1974 · S/N 402B0562N402WWPark Avenue Group Inc · Stuart, FLS/N 402B1061N4032CKrs Aerial Inc · Galloway, OHS/N 310R1351N403AJAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 1972 · S/N 402B0305N403RMUlpiano Amy L · Carolina, PRS/N 402B0836N404JRBowlin & Associates Inc · Clayton, GAS/N 421C0317N4079CCalled To Care Residential Facility LLC · Avondale, AZBuilt 1978 · S/N 310R1364N40JCDbs Aviation LLC · Sulphur Springs, TXBuilt 1973 · S/N 421B0384N40MEUnlimited Boat Sales Inc · Page, AZS/N 421C1241N40RUMoore Terry Alexander Trustee · Adel, GABuilt 1980 · S/N 421C0878N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576N41085421 Bravo LLC · Marine City, MIS/N 421B0440N410AJSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 421C1093N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422N410WMFlying Life LLC · Middleburg, FLBuilt 1975 · S/N 310R0578N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458N41124Wenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1973 · S/N 421B0465N411CKFairchild Bill R · Dalhart, TXS/N 421C0229N411MZSongbird Air LLC · Lakewood, COBuilt 1980 · S/N 421C1002N411TBLewis Nathan · North Plains, ORS/N 421B0481N411ZJkdj LLC · Tyler, TXBuilt 1973 · S/N 421B0482N413VVGardner John · New Hudson, MIBuilt 1979 · S/N 421C-0641N415RABoas Mark S · Hollywood, MDBuilt 1975 · S/N 421B0874N4162GWillman Loren · Nevada City, CAS/N 421C0426N4167GW J Medical Consulting · Caguas, PRBuilt 1976 · S/N 402B1214N4169GNewell Henry O Jr · Roxboro, NCS/N 402B1215N418BMOrion Aircraft Holding LLC · Rocky Mount, VABuilt 1982 · S/N 421C1227N41AYHunterdon Aviation Inc · Ringoes, NJBuilt 1978 · S/N 310R1416N41CUEncinal Aviation LLC · Springfield, MOS/N 421C0318N41LJPic Aviation Group LLC · Cornelia, GABuilt 1982 · S/N 421C1252N41PBCrestview Residential Properties LLC · Laurinburg, NCBuilt 1974 · S/N 421B-0845N41SPN41sp LLC · New Port Richey, FLBuilt 1975 · S/N 421B0937N41WFJack Ryan Aviation · Woodcliff Lake, NJBuilt 1976 · S/N 421C0205N41WTPremiere Aviation Inc · Concord, CABuilt 1982 · S/N 421C1257N4200CEagle Point Homes LLC · Baytown, TXBuilt 1977 · S/N 421C0343N420HLJannelli Gilbert DBA · Clearwater, FLExpired dealerS/N 402B-0335N420WESwv Aviation LLC · Winter Park, FLBuilt 1981 · S/N 421C1040
Back to AD 75-23-08 R5