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.

N364BFFlying B Partners LLC · Wichita, KSBuilt 1977 · S/N E-1166N364BGBehrens Julie A · Crested Butte, COS/N E-3559N364CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N FL-346N364CLLacy Clay Trustee · Los Angeles, CABuilt 1981 · S/N 383N364DBHirsch Benjamin M · Orange Park, FLBuilt 1995 · S/N E-2963N364DDJd Bonanza LLC · Mesa, AZBuilt 1996 · S/N E3056N364DFBlackley Nathan · Eugene, ORBuilt 1997 · S/N E-3091N364EMSafeco Leasing LLC · Port Alsworth, AKBuilt 1968 · S/N E-56N364HPZadeh Alidad Trustee · El Centro, CABuilt 1973 · S/N E-402N364JBBlazie Marketing Services Inc · Street, MDBuilt 1997 · S/N E-3079N364PKSky Hawk LLC · Moody, ALBuilt 1999 · S/N 525-0320N364SCTfs Inc · Chelsea, ALBuilt 2001 · S/N E-3374N364VKPetts Adam · Waukee, IABuilt 1981 · S/N E-1973N364WPPorter Flying Service · Durham, CAS/N E-1914N365ARTwin Otter International Ltd · Las Vegas, NVBuilt 1973 · S/N 365N365CSN365cs LLC · Mcallen, TXS/N FA-120N365EARubi Aviation Inc · Dallas, TXBuilt 1991 · S/N 560-0107N365FDci Air LLC · Dodge City, KSBuilt 1980 · S/N 421C0854N365HPVasi LLC · Dripping Springs, TXBuilt 1980 · S/N E-1756N365PTTap One LLC · Lexington, KYBuilt 2015 · S/N FL-999N365RVTwin Oaks Aviation Inc · Pipersville, PAS/N E-1840N365SMIntegrated Transportation Services LLC · Tupelo, MSBuilt 2007 · S/N 525-0658N365SNNice Neighbors LLC · Wilmington, NCBuilt 1996 · S/N 525-0121N365SZSheetz Aviation Inc · Altoona, PABuilt 2017 · S/N FL-1087N3663QOmalley Edward · Boulder, COBuilt 1980 · S/N E-1691N3664TJdm Aviation LLC · Marceline, MOBuilt 1980 · S/N E-1692N3664YWindswept Aviation LLC · North Canton, OHBuilt 1980 · S/N E-1693N36665Flynn Michael · Weybridge SurreyBuilt 1980 · S/N E-1696N3666ASandow Dean · Scappoose, ORBuilt 1969 · S/N E-190N36673Gta Air Inc · Addison, TXBuilt 1980 · S/N TH-1143N3668URedmond John L · Santa Clarita, CABuilt 1980 · S/N E-1701N366CCConquest Logistics Inc · La Quinta, CAS/N FL-366N366GWK&K Leasing Inc · Tea, SDBuilt 1979 · S/N LW-320N366HPRey Del Cielo LLC · San Antonio, TXBuilt 1974 · S/N E-632N366PSkyway Unlimited Inc · New London, NCBuilt 1997 · S/N E-3099N366WDAirmann Leasing LLC · Mount Sterling, KYBuilt 2007 · S/N FL-555N366ZMendel Carl · Port Charlotte, FLBuilt 1975 · S/N E-769N3671MFigvam LLC · New York, NYBuilt 1980 · S/N E-1705N3673RArtie Aircraft LLC · Trenton, MOBuilt 1980 · S/N TH-1150N3673UCastor Care LLC · Mount Pleasant, SCBuilt 1980 · S/N TH-1149N3674GSudduth Ronald C · Lineville, ALBuilt 1980 · S/N TH-1151N3675RCl1 LLC · Baton Rouge, LABuilt 1980 · S/N E-1711N3675TFairbairn Stephen C · Carmel, INBuilt 1980 · S/N E-1672N36787Manairco Inc · Wooster, OHBuilt 2004 · S/N E-3587N3679ZKlein Eric · Tenino, WABuilt 1980 · S/N E-1730N367DMarquardt James H · Warner Robins, GABuilt 1979 · S/N E-1619N367HPN367hp LLC · Aberdeen, SDBuilt 1981 · S/N E-1811N367JCWalter Oil & Gas Corp · Houston, TXS/N 560-0069N367STTechnology Service Corp · Arlington, VABuilt 2002 · S/N FL-341N367TPCmmr LLC · Oxford, MSBuilt 2021 · S/N FL-1274
Back to AD 2006-16-18 R1