OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,798

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-16-18-R1')
    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-16-18-R1')
  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.

N797BKBlue Bird Of Happiness LLC · Shreveport, LABuilt 2018 · S/N 525-1001N797CFAmerican Aviation Inc · Brooksville, FLBuilt 1978 · S/N LJ-797N797MMNext Generation Aviation LLC · Beloit, WIBuilt 1990 · S/N 5600078N797SEShows Douglas W · Seabrook, TXBuilt 1980 · S/N 501-0151N798FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0174N798GMJust US Pilots Inc · Clearwater, FLBuilt 1998 · S/N E-3184N798JBMidwest Aircraft LLC · Olathe, KSBuilt 2002 · S/N E-3468N798JSLtn Aviation LLC · Draper, UTBuilt 2008 · S/N 560-0796N798PAJli Holdings Group Inc · Johns Island, SCS/N 258070N799ALDelt Holdings Orange LLC · Dubuque, IABuilt 1988 · S/N FA-157N799GKCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-799N799MCPerry King Air LLC · Perry, GABuilt 1982 · S/N BB-998N799RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 258708N799SN143bl LLC · Hixson, TNBuilt 2002 · S/N 258588N79AJCal Avia LLC · Fresno, CABuilt 1999 · S/N 525-0321N79CEBe 58 Corp · Rochester, NYS/N TH-2099N79CJV1vr LLC · Wilmington, DEBuilt 1981 · S/N 179N79DMKsg Capital LLC · Casper, WYBuilt 1981 · S/N BB-853N79EFPonca International LLC · Ponca, ARS/N BB1350N79HCBmc Group · Hawthorne, CABuilt 1990 · S/N E-2538N79HEMontauk Flying Inc · Montauk, NYBuilt 2004 · S/N E-3542N79JFFour Twenty One LLC · Kalispell, MTBuilt 1977 · S/N 421C0340N79MCKruse Air LLC · Sheridan, WYBuilt 1981 · S/N E-1903N79PHMaxus Capital Group LLC · Cleveland, OHS/N 96029N79TEPollard Aircrfaft Sales Inc · Fort Worth, TXBuilt 1985 · S/N FA-67N79TSTasair LLC · Minocqua, WIBuilt 2001 · S/N 258511N7ABBce Jets LLC · Cuero, TXBuilt 1996 · S/N 650-7068N7BW7bw LLC · Lewes, DEBuilt 1973 · S/N E-395N7CJPropart Inc · Austin, TXBuilt 1990 · S/N E-2575N7CQEfc Aircraft LLC · Missoula, MTBuilt 1993 · S/N 525-0004N7DHBrown Michael D · Bloomington, INBuilt 1970 · S/N TH-118N7DMNix Terry W · Golden, MSBuilt 1972 · S/N TH-214N7ENJkh Power LLC · Wilmington, DEBuilt 1980 · S/N 501-0302N7EVYellow Star Mgmt LLC · Waco, TXBuilt 1998 · S/N E-3162N7FHGroh David · Mason, MIBuilt 1977 · S/N E-1142N7JKosco Matthew D · Munster, INBuilt 2000 · S/N E-3316N7MCSt Tammany Parish Mosquito Abatement District · Slidell, LABuilt 1967 · S/N 40N7MHFlying Hare LLC · High Point, NCBuilt 1994 · S/N 525-0081N7MWSeven Aces LLC · Chesterfield, NJBuilt 1982 · S/N TH-1353N7MZN7mz LLC · Omaha, NEBuilt 1981 · S/N 501-0217N7NANasa Armstrong Flight Research Center · Edwards, CABuilt 1982 · S/N BB-997N7NKHall Gregory Lyman · College Station, TXBuilt 1993 · S/N E-2786N7PD426th Aero Squadron LLC · Cropwell, ALBuilt 2000 · S/N TH-1972N7PRRed Aero LLC · Batesville, INBuilt 1974 · S/N E-622N7RCRing Air LLC · Dover, DEBuilt 2009 · S/N FL-621N7RLRbr Development LLC · West Plains, MOS/N LJ-1161N7RZZantop Reese C Trustee · Naples, FLBuilt 1990 · S/N E-2562N7TKMellon Timothy · Saratoga, WYBuilt 1979 · S/N 501-0116N7WFFang Aviation LLC · Wichita Falls, TXBuilt 1999 · S/N 650-7106N7YYNejad Shahpour M · Gresham, ORFirst renewal noticeBuilt 1986 · S/N E-2333
Back to AD 2006-16-18 R1