AD 72-03-06

Registered aircraft · 758

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

N122JLotus Aviation LLC · Boring, ORBuilt 1976 · S/N 2035N123MGHagedorn Aviation Inc · Columbus, OHBuilt 2001 · S/N 29003CN123NMAglk LLC · Lewes, DES/N 6702N124EHJbp Aviation LLC · Henderson, NVS/N S559N124PDH & O Helicopters Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0502EN126KWHlh Leasing LLC · Wilmington, DEBuilt 1991 · S/N 0489EN12AAAllsouth Aviation LLC · Buford, GABuilt 1996 · S/N 52165N12BFHutter Charles G · Carson City, NVBuilt 1974 · S/N 61P-0162-003N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069N12THHarding Tim · Bryan, TXS/N 0224EN130BHObrien Helicopters Inc · Lehigh Acres, FLBuilt 1975 · S/N 1776N130JHRanger Aviation Leasing LLC · Wilmington, DES/N 4166N131AEAtwood Aviation LLC · Pickerington, OHBuilt 1988 · S/N S787N137AGTop Gun Precision Ag LLC · Skidmore, TXBuilt 1975 · S/N 1832N137HSHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1977 · S/N 2292N13KJCarlston Carl Vaughn · Murray, UTBuilt 1991 · S/N 0444EN142CCMachinery Service Co Inc · Wiscasset, MEBuilt 1997 · S/N 5025N146ETFour Creeks Aviation Inc · Visalia, CABuilt 1976 · S/N HA3046N146SHScott'S Helicopter Services · Le Sueur, MNBuilt 1973 · S/N 957N14807Hammock Flying Service Inc · Smithville, ARBuilt 1972 · S/N 25078N14837Oscar Aerial Spraying LLC · Grady, OKBuilt 1972 · S/N 850N150AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090201MN150F11 11 Enterprises LLC · San German, PRBuilt 1975 · S/N 1866N152CAChem Air LLC · Shreveport, LABuilt 1978 · S/N 2342N153SAHodges Terry A · West Branch, MIBuilt 1968 · S/N 68-16711N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339N158DWSolamente Air LLC · Fort Wayne, INBuilt 1972 · S/N 72-21365N15THHeliservice LLC · Wilmington, DEBuilt 2003 · S/N 0564EN16002Commonweath Of Massachusetts · East Boston, MAS/N 0194EN1602LSaxton Helicopter Leasing LLC · Plymouth, MIS/N 0225EN1604ZDept Of Fish Wildlife And Parks · Helena, MTBuilt 1989 · S/N 0341EN16050Venturi Aviation LLC · Missoula, MTS/N 0276EN16062Flight Inspection LLC · Springdale, WABuilt 1989 · S/N 0349EN16069Paragon Air Group · Fort Worth, TXBuilt 1990 · S/N 0433EN1610BBlackstead Investments Inc · Boise, IDBuilt 1991 · S/N 0480EN1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044N162SHCastro Be LLC · Wilmington, DES/N 7607N164KMemphis Police Department · Memphis, TNBuilt 1988 · S/N 4000N164RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53140N165JKBohica Consulting Services Of Nevada Inc · Boulder City, NVBuilt 1980 · S/N 2930N166MBHelicopter Roundup Service LLC · Nephi, UTBuilt 1980 · S/N 1000831DN16715Cahaba Forestry Services LLC · Flowood, MSBuilt 1976 · S/N 2110N16EYCarleton Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0501EN16JDTriple F Flying Inc · Benton, PABuilt 1971 · S/N 71-20435N16QRegistration Pending · Fredericksburg, VARegistration pendingS/N 1290227SN170SSOlathe Spray Service Inc · Olathe, COBuilt 1963 · S/N 2827N171WHWestwind Helicopters Inc · Santa Fe, TXBuilt 1997 · S/N 53149N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170N174ECBingham Larry F · Juneau, AKBuilt 1969 · S/N 791246N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075
Back to AD 72-03-06