OpenAirDocs.org
AD 2007-17-17

Registered aircraft · 830

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-17-17')
    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-17-17')
  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.

N100FKFk Air LLC · Newark, DEBuilt 2000 · S/N 113N100KZLear 100kz LLC · Austin, TXBuilt 1999 · S/N 065N101AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 36-008N103EZ103ez LLC · Champaign, ILBuilt 2011 · S/N 418N103JLThunderun Aviation Corp · Buffalo, NYBuilt 1990 · S/N 026N103TDTrigger Air LLC · Wilmington, DES/N 31-006N106GKVrs Holdings LLC · Medina, OHBuilt 2013 · S/N 2134N108JNPremier Jets Inc · Hillsboro, ORBuilt 1980 · S/N 35A-358N108KNStuckey Connections LLC · Magnolia, TXBuilt 2007 · S/N 336N108RBAerotrust Services Corp Trustee · Wilmington, DEBuilt 1976 · S/N 097N109LWWeisbrod & Weisbrod Pc · Dallas, TXBuilt 2000 · S/N 071N10FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 015N10GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 010N10JMov Aviation LLC · Wilmington, DEBuilt 2007 · S/N 337N10NLO Neal Industries Inc · Birmingham, ALBuilt 2000 · S/N 128N10VJVenture Jets LLC · Lititz, PABuilt 1990 · S/N 018N111KRLs 464 LLC · Colorado Springs, COBuilt 1981 · S/N 464N115LJUmb Bank Na Trustee · Salt Lake City, UTS/N 2115N116ASRa Sails LLC · Owasso, OKBuilt 2000 · S/N 078N116MAFsa Aerospace Inc Trustee · Wilmington, DEBuilt 1977 · S/N 029N116PJForty Er LLC · Bethany, OKS/N 2027N118RKTaber Air LLC · Oklahoma City, OKBuilt 2006 · S/N 296N11GJGlobal Jetcare Inc · Brooksville, FLBuilt 1981 · S/N 425N121LJN121lj LLC · Elmira, NYBuilt 1996 · S/N 121N125FSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1996 · S/N 125N125QMed Air LLC · Lawrenceville, GABuilt 2000 · S/N 027N126BKAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2000 · S/N 068N126KLAircraft Fidelity Corp Trustee · Dover, DEBuilt 1984 · S/N 096N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212N129TKBankair Inc · West Columbia, SCBuilt 1979 · S/N 253N12FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 016N12JSJs Aircraft Leasing III LLC · Aventura, FLBuilt 2017 · S/N 561N12RPRoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 278N12VQDtm Aviation LLC · Statesboro, GABuilt 2007 · S/N 324N131JXCbr Aviation LLC · Delaware, OHBuilt 2012 · S/N 450N132LJAery Aviation LLC · Wilmington, DEBuilt 1977 · S/N 032N132NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 438N133EJHale William Trustee · Loveland, COBuilt 1977 · S/N 133N133VSVrs Holdings LLC · Medina, OHBuilt 2006 · S/N 2060N135AJN135aj LLC · Englewood, COBuilt 1975 · S/N 036N135SHMed Air LLC · Wilmington, DEBuilt 1981 · S/N 335N136DHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 036N136JPCasmos LLC · Wilmington, DES/N 35A-359N137BRCimarron Aviation LLC · El Paso, TXBuilt 2007 · S/N 45-2068N139LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 139N140HMHarbert Aviation 40 LLC · Birmingham, ALBuilt 2008 · S/N 2103N141JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 2010N143LJBchjet3 LLC · Greer, SCS/N 143N145APKress Enterprises Inc · Brimfield, ILBuilt 2006 · S/N 300
Back to AD 2007-17-17