AD 2006-10-21

Registered aircraft · 44,908

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

N278KERotor Technologies Inc · Nashua, NHBuilt 2006 · S/N 11178N278MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881019N278MHSimms Hospitality Group LLC · El Segundo, CABuilt 2022 · S/N 3400N278NDRegistered aircraftBuilt 2002 · S/N 2844069N278RCSanborn Map Company Inc · Colorado Springs, COBuilt 1978 · S/N 31-7912018N278SHSmith Kenneth S Jr · Uvalde, TXBuilt 2007 · S/N 4224N278SJOrr George Douglas · Hood River, ORBuilt 2000 · S/N 113N278SPSvetful Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9474N2790WMoondogger LLC · Yakima, WAS/N 1068N27917Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1978 · S/N 31-7952007N27918Reneau Thomas E · Midland, TXBuilt 2001 · S/N 2974N2791WToothman John · Fairmont, WVS/N 1069N2793WSchneider Aerial Inc · Rugby, NDBuilt 1966 · S/N 3365N2793Y3y Leasing LLC · Englewood, COBuilt 1958 · S/N TD-166N2796WPennington Jeffrey B · Wrightwood, CABuilt 1966 · S/N 1072N2797WWebb John H Jr · Paulding, OHBuilt 1966 · S/N 1073N27987Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 31-7912054N27989Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-7952077N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228N2798WSb Enterprise LLC · Marshall, TXBuilt 1966 · S/N 3367N27990Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1979 · S/N 31-7952079N279AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496507N279CGDelaware State University · Dover, DEBuilt 2000 · S/N 2843399N279JHBravo Zulu Aviators LLC · Midland, TXBuilt 1978 · S/N 32-7840138N279LGAltius Aviation LLC · Syracuse, NYBuilt 1986 · S/N 28-8611004N279MASd Aviation LLC · Danville, CABuilt 2007 · S/N 1040-2007N279MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881020N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034N279PWMauck Ryan S Trustee · Bend, ORBuilt 1985 · S/N 28-8590059N279WYMccarty David · Baker City, ORBuilt 2017 · S/N 3279N27AMThom Jacob D · Wasilla, AKBuilt 1990 · S/N 001AMN27AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843768N27AZGilbert John K · Austin, TXBuilt 2022 · S/N 1217N27BEAir N Nautical LLC · Kalispell, MTBuilt 1998 · S/N 1418N27BLFairmont State University · Fairmont, WVBuilt 2020 · S/N 172S12467N27BRLarson Allen L · Capron, ILBuilt 1969 · S/N 24-4909N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118N27DASiewruk Cameron M · Stuart, FLBuilt 1978 · S/N 32-7840084N27DRN504fl LLC · Killeen, TXBuilt 2003 · S/N 24703N27DVDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N T20608111N27EKPrecision Aviation Training LLC · Newberg, ORBuilt 2022 · S/N 1311N27FMGogoplex LLC · Wilmington, DEBuilt 1976 · S/N 27-7654087N27GSMazzola Michael · Baton Rouge, LABuilt 1977 · S/N 28R-7737160N27GWWatson Gary R · Modesto, CABuilt 1982 · S/N 0002N27GZKelly Kristofor · Belton, TXBuilt 2000 · S/N 01N27HCCranston Courtland L · Santa Rosa, CAS/N 1N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034N27HRRemer Herbert I · Punta Gorda, FLBuilt 1999 · S/N 1444N27HUOlson Dorian J · Lake Park, MNBuilt 1997 · S/N 1359N27HWJacobs Jim · Great Barrington, MABuilt 2018 · S/N 1177-2018
Back to AD 2006-10-21