OpenAirDocs.org
AD 75-22-03

Registered aircraft · 130

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-22-03')
    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-22-03')
  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.

N101SYRegistered aircraftBuilt 1970 · S/N 201374N105UADown East Emergency Medicine Institute · Orono, MES/N 880723N107BNBig Boy Toys LLC · Mars, PAS/N 701438N1133CSara Helicopters Inc · Wilmington, DEBuilt 1974 · S/N 940636SN115ECSara Helicopters Inc · Wilmington, DEBuilt 1971 · S/N 110292SN119TTaylor Robert T · Chehalis, WABuilt 1976 · S/N 760844SN11ZXBig Bird Leasing Inc · Saint Peter, MNBuilt 1974 · S/N 640609SN126SRDown East Emergency Medicine Institute · Orono, MES/N 1091299N12964Sunflower Aero Inc · Atwood, KSS/N 570049N133BHBrown Helicopter Inc · Pensacola, FLBuilt 1969 · S/N 990122SN138SRDown East Emergency Medicine Institute · Orono, MES/N 391106N13SDSnohomish County Sheriffs Office · Snohomish, WAS/N 380376N13WDGrayman Group LLC · Coeur D Alene, IDBuilt 1975 · S/N 150685SN142SCSpartanburg County Sheriffs Office · Spartanburg, SCS/N 1180910N150AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090201MN160DAWehring Justin DBA · Clute, TXBuilt 1969 · S/N 391115N16QRegistration Pending · Fredericksburg, VARegistration pendingS/N 1290227SN17167Slade Aviation LLC · Carlsbad, NMBuilt 1969 · S/N 491127N174ECBingham Larry F · Juneau, AKBuilt 1969 · S/N 791246N17801Mckee John R · Central Point, ORBuilt 1968 · S/N 380352N187YMBrown Byron Tim · Hermiston, ORS/N 691183N191VSVertol Systems Co Inc · Destin, FLS/N 800-766DN192VSVertol Systems Company Inc · Destin, FLBuilt 1980 · S/N 1000786DN194VSVertol Systems Company Inc · Destin, FLS/N 800-767DN196VSVertol Systems Company Inc · Destin, FLBuilt 1980 · S/N 900787DN2091RCity Of El Paso Police Department · El Paso, TXS/N 380381N21772N21772 LLC · Wellington, FLBuilt 1967 · S/N 970134N259BKCavanaugh Collections Inc · Addison, TXBuilt 1970 · S/N 301376N262SDCullman Police Department · Cullman, ALS/N 691218N278KCCullman Police Dept · Cullman, ALS/N 201371N298SDCsw LLC · Anacoco, LABuilt 1968 · S/N 280332N301SDHarrison County Sheriffs Department · Gulfport, MSBuilt 1967 · S/N 1070131N3051QCharlie Helicopter Company LLC · Sierra Blanca, TXBuilt 1974 · S/N 540601SN305AZJta Express Inc · Wilmington, DEBuilt 1968 · S/N 480446N3121QC&D Helicopters LLC · Spanish Fork, UTBuilt 1976 · S/N 950768SN313JPPerell John · Miami Beach, FLBuilt 1972 · S/N 1120428SN330CMDewind Helicopter Services LLC · Zeeland, MIS/N 291060N332ABUsda Aphis Ws Atoc · Cedar City, UTS/N 791231N363JSWilson Robert B · Superior, AZBuilt 1973 · S/N 930517SN369AVVista I Inc · Smithville, OHBuilt 1970 · S/N 110282-SN369DB110288s Inc Trustee · Wilmington, DES/N 110288-SN369DFPerry James · Monroe, WAS/N 820404SN369DRReynolds Darryl G · Wills Point, TXBuilt 1967 · S/N 67-16647N369FLVasilescu Paul · Hoboken, NJS/N 560819SN369GNBig Bird Leasing Inc · Saint Peter, MNS/N 140553SN369GSHellyer Aviation · Worland, WYBuilt 1973 · S/N 1230548SN369HAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 660821SN369HEN369he LLC · Wickenburg, AZBuilt 1969 · S/N 1090205EN369HSPurcell Ian · San Diego, CABuilt 1976 · S/N 850763SN369KECbft LLC · Mobile, ALBuilt 1969 · S/N 991271
Back to AD 75-22-03