OpenAirDocs.org
AD 2005-10-13

Registered aircraft · 1,224

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

N206ABBlue Sky Air Services LLC · Wilmington, DEBuilt 1972 · S/N 9053N206ACAirconnor LLC · Livingston, MTBuilt 1981 · S/N 3521N206AJVertical Air LLC · Wilmington, DEBuilt 1972 · S/N 878N206ALVertical Vegetation Management LLC · Darlington, INBuilt 1979 · S/N 2879N206BBNixon Helicopters LLC · Mentone, CABuilt 1967 · S/N 112N206BESummit Helicopters Inc · Salem, VABuilt 1978 · S/N 2375N206BMWg Northland LLC · Seeley Lake, MTBuilt 2000 · S/N 4537N206BPAirman Helicopter Inc · Fort Lauderdale, FLBuilt 1973 · S/N 1231N206BWWesson William D · Lincoln, ALBuilt 1990 · S/N 4121N206BXCoastal Helicopters Inc · Panama City, FLBuilt 1979 · S/N 2872N206CHNorthwest Helicopters I Inc · Olympia, WABuilt 1975 · S/N 1735N206CJCb Couch Inc · Walcott, ARBuilt 1992 · S/N 51579N206CSMarietta Concrete Repair LLC · Marietta, OHBuilt 1989 · S/N 4068N206DDInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 3627N206DGSierra Papa Aviation LLC · Holdrege, NEBuilt 1982 · S/N 3679N206DPMiddlesex County Mosquito Extermination Commission · Edison, NJBuilt 1995 · S/N 4346N206EGAir Lift International LLC · Las Vegas, NVFirst renewal noticeBuilt 1975 · S/N 1570N206ESWaverly 206 LLC · Oklahoma City, OKBuilt 1976 · S/N 2053N206GLRotorwings Aviation LLC · Hebron, NES/N 2929N206HESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 2880N206JSMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 3632N206JTTurner Jeffrey A · Birch Run, MIBuilt 1978 · S/N 2545N206JZMercer-Fraser Co · Eureka, CABuilt 1984 · S/N 3795N206KSBailey April O · Papillion, NEBuilt 1976 · S/N 1927N206LDPitzer Cheryl · Nevada, TXBuilt 2007 · S/N 4646N206MJTeufel Jessica L DBA · Hillsboro, ORBuilt 1981 · S/N 3236N206NAInternational Air Services Inc Trustee · Carson City, NVBuilt 1972 · S/N 708N206NYHornet International LLC · Picayune, MSBuilt 1989 · S/N 4069N206PC10wg LLC · Newman Lake, WABuilt 1984 · S/N 3776N206PHTaz Investments LLC · New Iberia, LABuilt 1969 · S/N 431N206PLAerial Control Inc · Brentwood, CABuilt 1985 · S/N 3902N206RMPadgett Farms And Forestry LLC · Milan, GABuilt 1974 · S/N 1566N206RVTaylor Made Aircraft Co LLC · Broomfield, COBuilt 1981 · S/N 3230N206RWUnited States Department Of Interior · Boise, IDBuilt 1995 · S/N 4372N206RYEast Tennessee Helicopters Inc · Butler, TNBuilt 1979 · S/N 2807N206SAGarlick Joyce M · Hamilton, MTBuilt 1973 · S/N 1013N206SWCounty Of Ocean · Barnegat, NJS/N 4091N206TATomlinson Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 3319N206TGGallien Anthony · Livermore, CABuilt 1979 · S/N 2610N206THRanger Aviation Leasing LLC · Wilmington, DEBuilt 1975 · S/N 1736N206VLMalahaide Investments Inc · Wilmington, DEBuilt 1978 · S/N 2389N206WAChem Air LLC · Shreveport, LABuilt 1980 · S/N 3037N206WGWorld Golf LLC · Charles City, VABuilt 1979 · S/N 2833N206XZSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 3645N206YYMshr Helicopter Service LLC · Chehalis, WABuilt 1968 · S/N 132N206ZZAv Enterprises Inc · Bozeman, MTBuilt 1997 · S/N 4459N207TVMidcoast Helicopter Inc · La Ward, TXBuilt 1979 · S/N 2696N208ERAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 4527N208RJBoswell Fredric R · Amherst, NHBuilt 2014 · S/N 5190N209SKalispell Corp · Wilmington, DEBuilt 1981 · S/N 3511
Back to AD 2005-10-13