OpenAirDocs.org
AD 2006-08-13

Registered aircraft · 124

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-08-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:2006-08-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.

N53STBlue Link LLC · Bay City, WIBuilt 2002 · S/N 560-0624N552CNRer Plane LLC · San Antonio, TXBuilt 2004 · S/N 560-0674N554VPJl Diversified LLC · Scottsdale, AZBuilt 2001 · S/N 560-0554N557PGCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 2003 · S/N 560-0557N55MWCitation 560 LLC · Oshkosh, WIBuilt 2005 · S/N 560-0688N560BLKac Md LLC · Fort Mill, SCBuilt 2002 · S/N 560-0633N560BMBruce Tanski Construction & Development LLC · Halfmoon, NYBuilt 2004 · S/N 560-0668N560CBAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2004 · S/N 560-0655N560CE5 Star Aviation LLC · Aurora, MOBuilt 2001 · S/N 560-0555N560CXSpudaire LLC · Pasco, WABuilt 2001 · S/N 560-0582N560FPEdwards Carl E Jr Trustee · Oklahoma City, OKBuilt 2001 · S/N 560-0566N560HKa N22cr LLC · Lewes, DEBuilt 2001 · S/N 560-0576N560HMG Money LLC · Delavan, WIBuilt 2006 · S/N 560-0699N560JW3640 Aviation LLC · Mandeville, LABuilt 2001 · S/N 560-0560N560LFCamelot Express LLC · Roswell, GABuilt 2004 · S/N 560-0662N560LTLife Time Inc · Chanhassen, MNBuilt 2000 · S/N 560-0541N560MRCitation Associates Inc · New Castle, DEBuilt 2002 · S/N 560-0594N560PPEncore Aviation Holdings LLC · Jacksonville, FLBuilt 2005 · S/N 560-0687N560RMKa LLC · New Paris, INBuilt 2004 · S/N 560-0658N560SAGolden Air Inc · Dover, DEBuilt 2004 · S/N 560-0660N560WDAbbott Air Inc · Hydro, OKBuilt 2003 · S/N 560-0643N561FPZulu Romeo LLC · Ontario, ORBuilt 2001 · S/N 560-0561N563MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0550N564MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0569N568TXSpray Brothers Aviation LLC · Great Bend, KSBuilt 2001 · S/N 560-0558N56FSSunny Skies Kc LLC · Leawood, KSBuilt 2002 · S/N 560-0600N56KGBlue Yonder LLC · Portland, ORBuilt 2001 · S/N 560-0563N583TL518mv Air LLC · Modesto, CABuilt 2001 · S/N 560-0583N58DRocketman Rocketeers Lc · Austin, TXBuilt 2005 · S/N 560-0690N591DKIron Ring Aviation LLC · Portland, ORBuilt 2001 · S/N 560-0591N595KWGeronimo Aviation LLC · Burlison, TNBuilt 2002 · S/N 560-0595N5WTShell Air LLC · Liberty Township, OHBuilt 2003 · S/N 560-0635N600BWLambert Mcguire Management LLC · Austin, TXBuilt 2004 · S/N 560-0671N608CEEmb Aviation LLC · Tulsa, OKBuilt 2002 · S/N 560-0608N610RSRsc 1972 LLC · Valdosta, GAFirst renewal noticeBuilt 2002 · S/N 560-0610N622TFN9cr LLC · Hilton Head Island, SCBuilt 2002 · S/N 560-0622N632GUFlyarnd LLC · Tyler, TXBuilt 2001 · S/N 560-0562N648ASale Reported · Chicago, ILSale reportedBuilt 2004 · S/N 560-0657N652SJVddcpj Inc · Riverside, CABuilt 2004 · S/N 560-0652N664CEPride Aviation Support LLC · Exeter, PABuilt 2004 · S/N 560-0664N676TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 560-5367N681JZDanco Builders · Arcata, CABuilt 2004 · S/N 560-0681N682DGDpr Group LLC · Marshall, TXBuilt 2004 · S/N 560-0673N691TWSage Holdings LLC · Woodward, OKBuilt 2005 · S/N 560-0691N695AKAlascom Inc · Anchorage, AKBuilt 2005 · S/N 560-0695N6TRJmr Aviation LLC · Midland, TXBuilt 2001 · S/N 560-0573N700NKBoring Plane LLC · Columbia, MOBuilt 2006 · S/N 560-0700N707WWgi Leasing Inc · Vancouver, WABuilt 2001 · S/N 560-0556N70ECKb Air LLC · Mason, OHBuilt 2002 · S/N 560-0609N711XSSteiner Gp LLC · Weatherford, TXBuilt 2004 · S/N 560-0678
Back to AD 2006-08-13