OpenAirDocs.org
AD 82-12-04

Registered aircraft · 471

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

N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429N101ALRegistered aircraftBuilt 1980 · S/N U20605684N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062N105HHHaddock Flying Service Inc · Salters, SCS/N 1307N105KAGillespie Todd · Trenton, SCS/N 401-0238N109DHHordon Kathleen R · Newburyport, MABuilt 1976 · S/N 57213N10JSSiegel Jerry S · Los Angeles, CAS/N 008N110WYSm1019 LLC · Polson, MTBuilt 1976 · S/N 00-24N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368N119PARicciardi Brian P · Hyannis, MAS/N 402B0610N1201WMagnum Aviation LLC · Goff, KSBuilt 1966 · S/N 7819N1203GWestern Pilot Service Inc · Phoenix, AZBuilt 1975 · S/N 414-0649N1211MArchangelair LLC · Wilmington, DES/N 29002CN1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653N1234WCuellar Mauricio Dominguez · Tampa, FLBuilt 1970 · S/N 414-0043N123MGHagedorn Aviation Inc · Columbus, OHBuilt 2001 · S/N 29003CN123NMAglk LLC · Lewes, DES/N 6702N1252GInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 414-0809N126BTSecure Storage Solutions LLC · Thomaston, GABuilt 1977 · S/N 4140909N12BFHutter Charles G · Carson City, NVBuilt 1974 · S/N 61P-0162-003N12QHawkes F Bryant · Lake Dallas, TXBuilt 1966 · S/N 401-0014N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069N142CCMachinery Service Co Inc · Wiscasset, MEBuilt 1997 · S/N 5025N142SDSch Aviation Inc Trustee · Kings LynnBuilt 1975 · S/N 414-0635N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333N146ETFour Creeks Aviation Inc · Visalia, CABuilt 1976 · S/N HA3046N14807Hammock Flying Service Inc · Smithville, ARBuilt 1972 · S/N 25078N14UAMilam Equipment LLC · Trussville, ALS/N 414-0605N1500G5 Lg LLC · Rome, GABuilt 1975 · S/N 414-0814N154TTHotel Sierra Aviation LLC · Texarkana, TXS/N 414-0950N1554TRegistration Pending · Tampa, FLRegistration pendingBuilt 1972 · S/N 414-0269N1556TCalifornia Energy Exchange Corp · Rancho Cordova, CABuilt 1972 · S/N 414-0271N1557TCessna 414 LLC · Lincoln, NEBuilt 1972 · S/N 414-0272N1563TN1563t LLC · Sheridan, WYS/N 414-0278N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339N1596TPlane Crazy Inc · Page, NDBuilt 1973 · S/N 4140376N1600TBpm Rentals Inc · Lincoln, CABuilt 1973 · S/N 414-0380N1603TMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1973 · S/N 414-0383N1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044N1616TDavila Alexander · Davie, FLS/N 414-0396N1618TRandolph James · Greensburg, PABuilt 1973 · S/N 414-0398N1621TBeats Driving Inc · Northbrook, ILBuilt 1973 · S/N 414-0401N1624TMelnik Charles J DBA · Omaha, NES/N 414-0404N1627TSierra Leasing LLC · Sheffield, ALBuilt 1973 · S/N 414-0407N1637TSmith Taylor · Amarillo, TXBuilt 1973 · S/N 414-0417N1646TOrellana Willson Daniel · Hesperia, CABuilt 1973 · S/N 414-0426
Back to AD 82-12-04