OpenAirDocs.org
AD 75-19-01

Registered aircraft · 67

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-19-01')
    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-19-01')
  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.

N1021N1021 Inc · Wilmington, DEBuilt 1972 · S/N 12016N112EESpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11330N1203NBracy Rodney E · Middleville, MIBuilt 1972 · S/N 12046N121JWGlobal Jet LLC · Missoula, MTBuilt 1975 · S/N 11299N13RABarney Adam Joseph · Altamonte Springs, FLBuilt 1975 · S/N 11235N1525Aviaton Business Corporation · Saint Louis, MOBuilt 1973 · S/N 12022N15CDCommander N15cd LLC · Miami, FLS/N 11177N162ALNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11231N197GBPonderosa Aviation LLC · Safford, AZBuilt 1975 · S/N 11282N222MEClearwater Airco LLC · Anchorage, AKS/N 11338N245CFEagle Creek Aviation Services Inc · Indianapolis, INBuilt 1976 · S/N 11313N24GTPia Avcenter LLC · Peoria, ILBuilt 1975 · S/N 11254N251ESLumphanan LLC · Adams, NEBuilt 1975 · S/N 11251N30854Cornerstone Financial Enterprises LLC · Mesquite, NVS/N 11229N31BVCourtney Aviation LLC · Columbia, CAS/N 11315N32ALAero Air LLC · Hillsboro, ORBuilt 1976 · S/N 11336N32GASpur Aviation Services Lc · Twin Falls, IDBuilt 1974 · S/N 11215N32WSPonderosa Aviation LLC · Safford, AZBuilt 1976 · S/N 11339N362SHFlight-Plan One LLC · Bay City, MIBuilt 1976 · S/N 11316N368TPDonohue Andrew · Tulsa, OKBuilt 1973 · S/N 12039N383HCAc690 LLC · Alpine, WYBuilt 1975 · S/N 11310N3869FElkhorn Aviation Inc · Baker City, ORBuilt 1973 · S/N 11141N38WAAirborne Support Inc · Houma, LABuilt 1974 · S/N 11169N414CUnited Trading Unlimited LLC · Princeton, NJS/N 12021N449LCTj Air Holdings Inc Trustee · Wilmington, DES/N 11187N4717VCourtney Aviation LLC · Columbia, CAS/N 11220N50DXYada Yada Yada Inc DBA · Fresno, CABuilt 1974 · S/N 11227N52PYJk Aviation LLC · Carson City, NVS/N 11196N57112Courtney Aviation LLC · Columbia, CABuilt 1975 · S/N 11263N57RSKolob Canyons Air Services Inc · Wilmington, DES/N 11149N60BMValiair Lc Trustee · Casper, WYS/N 11172N615DPRay Aircraft Leasing LLC · Tuscaloosa, ALBuilt 1976 · S/N 11317N6517VDesert Flyers LLC · Calexico, CABuilt 1973 · S/N 12037N66GWKolob Canyons Air Services Inc · Wilmington, DES/N 11174N674NMMartin Nicolas · Rolling Hills, CABuilt 1974 · S/N 11226N685LDPhoenixarrowcommander LLC · Key West, FLBuilt 1973 · S/N 12020N690AGCay Air LLC · Wilmington, DEBuilt 1976 · S/N 11327N690ARPonderosa Aviation LLC · Safford, AZBuilt 1974 · S/N 11155N690ASAero Commander N690as LLC · Kalispell, MTBuilt 1974 · S/N 11277N690BMCommander 690 Bm LLC · Manassas, VABuilt 1975 · S/N 11311N690CFN A Corp · Scappoose, ORBuilt 1974 · S/N 11168N690DDTropeano Construction Inc · Ocala, FLBuilt 1974 · S/N 11159N690EHSanborn Map Company Inc · Colorado Springs, COBuilt 1975 · S/N 11309N690HBPonderosa Aviation LLC · Safford, AZBuilt 1974 · S/N 11205N690HFRegistered aircraftBuilt 1975 · S/N 11298N690PKMilou 1 LLC · New York, NYS/N 11166N690PTCritical Mass Aviation LLC · Coral Springs, FLBuilt 1975 · S/N 11252N690RAMountain Aviation Enterprises LLC · Safford, AZBuilt 1972 · S/N 11010N690SDWoodward Properties LLC · Kalispell, MTBuilt 1975 · S/N 11287N690SGNeptune Aviation Services Inc · Missoula, MTBuilt 1974 · S/N 11146
Back to AD 75-19-01