OpenAirDocs.org
AD 2007-23-13

Registered aircraft · 597

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:2007-23-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:2007-23-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.

N560PEFortuna Travel Partners LLC · Burbank, CABuilt 1996 · S/N 560-0379N560PHM & S Aviation LLC · Wilmington, DEBuilt 1992 · S/N 560-0199N560PKAncira Autos LLC · San Antonio, TXBuilt 1991 · S/N 560-0133N560PPEncore Aviation Holdings LLC · Jacksonville, FLBuilt 2005 · S/N 560-0687N560PWWintermute Aviation LLC · Westport, CTBuilt 1991 · S/N 560-0101N560PYHardrock Transport LLC · Pulaski, VAS/N 560-0034N560REBlack Diamond Aviation LLC · Dover, DEBuilt 1992 · S/N 560-0156N560RHHarris Air Inc · Logan, UTBuilt 2007 · S/N 560-0773N560RKHoover Cc LLC · Rockport, TXBuilt 1997 · S/N 560-0407N560RMKa LLC · New Paris, INBuilt 2004 · S/N 560-0658N560RRLange Tim R · Corpus Christi, TXS/N 560-0012N560RTBas Part Sales LLC · Greeley, COBuilt 1991 · S/N 5600125N560RWRbw Enterprises Inc · Conshohocken, PAFirst renewal noticeBuilt 1992 · S/N 5600196N560RXHoldco Cv LLC · New York, NYBuilt 1996 · S/N 560-0378N560SAGolden Air Inc · Dover, DEBuilt 2004 · S/N 560-0660N560SMRds Wings LLC · Los Gatos, CABuilt 1989 · S/N 560-0017N560TACu III LLC · Stuart, FLBuilt 1997 · S/N 560-0430N560TLN560tl LLC · Amarillo, TXBuilt 1989 · S/N 560-0423N560TTPresto LLC · Renton, WABuilt 1995 · S/N 560-0293N560TXSav Aviation LLC · Jacksonville, TXBuilt 1996 · S/N 560-0382N560VXVia-560vx LLC · Leawood, KSBuilt 1999 · S/N 560-0512N560WDAbbott Air Inc · Hydro, OKBuilt 2003 · S/N 560-0643N560WHCenturion Air LLC · Windermere, FLBuilt 1989 · S/N 560-0013N560WRTree Top Aviation LLC · Lubbock, TXS/N 5600121N560WTCsw Aviation Services LLC · Dahlonega, GABuilt 1992 · S/N 560-0168N560WVN560wv LLC · Brunswick, GABuilt 1993 · S/N 560-0217N560WWJrnd Corp · Lewes, DES/N 560-0047N560ZSCape Romain Holdings LLC · Wilmington, DEFirst renewal noticeBuilt 1994 · S/N 560-0281N561CCAir Land Leasing LLC · Madera, CABuilt 1997 · S/N 560-0416N561CFTitan Air LLC · Pasco, WAS/N 560-0003N561CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1991 · S/N 560-0099N561DAPark Avenue Group Inc · Stuart, FLBuilt 1995 · S/N 5600314N561FPZulu Romeo LLC · Ontario, ORBuilt 2001 · S/N 560-0561N561JSDodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 5600413N561MTN561mt LLC · Clovis, NMBuilt 1991 · S/N 560-0122N561PAJmrkfly LLC · Naples, FLS/N 560-0116N561PFN561pf LLC · Richland, WABuilt 1990 · S/N 560-0048N561SRChrysler Aviation Inc · Van Nuys, CABuilt 1991 · S/N 560-0138N561WFDm Air LLC · Pasco, WABuilt 1992 · S/N 560-0182N562CLGrandview Air LLC · Eldridge, IAS/N 560-0768N563MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0550N563TMAlamance Aviation LLC · Wilmington, DEBuilt 1991 · S/N 5600124N564MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0569N564TBK3hw LLC · Pattison, TXBuilt 1991 · S/N 560-0141N564TJBranch Aircraft Leasing Inc · Ocala, FLBuilt 1997 · S/N 560-0432N565TTWright Tony Lee · Douglas, GABuilt 1989 · S/N 560-0023N566KBT3 Farms LLC · Godley, TXBuilt 1995 · S/N 560-0325N566VRR & C Aviation LLC · Vancouver, WABuilt 1998 · S/N 560-0480N567RWBuffalo Bayou Air LLC · Houston, TXBuilt 1996 · S/N 560-0394N568BBank Of Utah Trustee · Salt Lake City, UTS/N 560-0481
Back to AD 2007-23-13