OpenAirDocs.org
AD 95-12-23

Registered aircraft · 50

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

N103SLAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N 11735N125MMFox Tango Tango Inc · Houston, TXBuilt 1979 · S/N 11605N192LHHill Lawrence E · Marion, MTS/N 95019N218MSSasha Air LLC · Hingham, MABuilt 1981 · S/N 95041N225TDCat Air LLC · Melba, IDBuilt 1980 · S/N 11635N2609PNtail LLC · Sheridan, WYBuilt 1979 · S/N 11617N36JTAerial Surveys International LLC · Watkins, COBuilt 1980 · S/N 95-024N37SBZb Investments Ltd · Dallas, TXS/N 11724N47TTLon Air LLC · Miles City, MTBuilt 1979 · S/N 11600N48BANjia Air LLC · Montgomery, INS/N 11665N515AMAllen Myland Inc · Media, PABuilt 1980 · S/N 95008N51WFD&S Aircraft LLC · Gainesville, GABuilt 1981 · S/N 11684N52JWJ W Aviation LLC · Dover, DES/N 11619N57TBInternational Air Services Inc Trustee · Carson City, NVS/N 11613N580ERBlue Ocean Aerospace LLC · Fort Collins, COBuilt 1981 · S/N 11669N5878KClearwater Airco LLC · Anchorage, AKBuilt 1980 · S/N 11626N5926KGulfstream Aerospace Corp · Savannah, GABuilt 1981 · S/N 11674N5955KVolare Via LLC · Piqua, OHBuilt 1981 · S/N 11703N5956KSullivan Leo · Ofallon, ILS/N 11719N63DUCts Aviation Inc · Galesburg, MIBuilt 1979 · S/N 11601N64PSSchiff Peter · Cookeville, TNBuilt 1981 · S/N 11702N708PCAustin Point Aviation LLC · Portland, ORBuilt 1980 · S/N 95023N74EF3bk Source LLC · Wellington, FLBuilt 1979 · S/N 11614N800VBAerial Surveys International LLC · Watkins, COBuilt 1980 · S/N 11646N80PHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N 11691N840AKState Of Alaska · Palmer, AKBuilt 1980 · S/N 11643N840AMQueen Enterprises LLC · Wilmington, DES/N 11709N840BDDash One LLC · Newbury, NHS/N 11659N840CFPappusgrass Aviation LLC · San Antonio, TXBuilt 1980 · S/N 11624N840EETmc840 LLC · Bluffton, SCS/N 11729N840GHCrescent Valley Baling LLC · Corvallis, ORBuilt 1979 · S/N 11615N840JWRepax LLC · Erie, PABuilt 1981 · S/N 11658N840MD&G Aviation LLC · Denver, COBuilt 1980 · S/N 11657N840PNWest Transportation LLC · West Bloomfield, MIBuilt 1981 · S/N 11679N840PSChs Leasing LLC · Boca Raton, FLBuilt 1981 · S/N 11672N840RBGreat American Jet Inc · Cincinnati, OHBuilt 1981 · S/N 11699N840SEGreen Fairways Florida Inc · Key West, FLBuilt 1979 · S/N 11610N840TWNeptune Aviation Services Inc · Missoula, MTBuilt 1981 · S/N 11689N848LGPia Avcenter LLC · Peoria, ILBuilt 1980 · S/N 11641N850ACInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 11629N880GGarlynson Airways LLC · Lincoln, NEBuilt 1980 · S/N 95033N910FCSanborn Map Co Inc · Colorado Springs, COBuilt 1981 · S/N 11682N926SCCone S E Jr · Hobbs, NMBuilt 1980 · S/N 11622N980AETj Air Holdings Inc Trustee · Wilmington, DEBuilt 1981 · S/N 95078N980AKUniversal Pacific Investment Corporation · Portland, ORBuilt 1980 · S/N 11636N980BHKellogg Consulting LLC · San Antonio, TXBuilt 1980 · S/N 95002N980CWWells & West Inc · Murphy, NCS/N 95013N980EEPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 95039N980HBSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 95006N9812SAfk Leasing Services LLC · Ripon, WIS/N 95060
Back to AD 95-12-23