OpenAirDocs.org
AD 2012-08-16

Registered aircraft · 238

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:2012-08-16')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-08-16')
  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.

N60HJJacura Delaware Inc · Boca Raton, FLBuilt 2010 · S/N 378N60HMMrm Aviation LLC · Dallas, TXBuilt 1993 · S/N 016N60LJWorldwide Aircraft Services Inc · Tampa, FLBuilt 1995 · S/N 052N60LVPda LLC · Las Vegas, NVBuilt 2011 · S/N 400N60RLAti Jet Inc · El Paso, TXS/N 278N60VVSixty Something LLC · Mobile, ALBuilt 1997 · S/N 104N610CRDiamond Aviation LLC · Waynesburg, PABuilt 2008 · S/N 339N610FPDaviation LLC · Palm Harbor, FLBuilt 2002 · S/N 258N6144Meatball Martini Ejm LLC · Saratoga Springs, NYBuilt 2008 · S/N 347N614SHDaviation LLC · Palm Harbor, FLBuilt 1999 · S/N 171N618LM&N Equipment LLC DBA · Centennial, COBuilt 2003 · S/N 267N619JBBoll Air LLC · Siesta Key, FLS/N 274N61GDUnitedlink Inc · San Antonio, TXBuilt 1998 · S/N 147N61WFLuge One LLC · Longwood, FLBuilt 2006 · S/N 313N61WGRoman Aviation LLC · Helena, MTBuilt 2008 · S/N 361N620GTPapa'S Ladies LLC · Bosque Farms, NMBuilt 1997 · S/N 100N631BADlf-Air LLC · New Orleans, LABuilt 2013 · S/N 423N640SDBitterroot Leasing LLC · Helena, MTBuilt 1994 · S/N 60-040N649SENorthrop Grumman Systems Corp · El Segundo, CABuilt 2011 · S/N 390N64JPHill Country Jet Partners LLC · Spicewood, TXBuilt 2001 · S/N 246N65HUHop-A-Jet Worldwide Jet Charter Inc · Fort Lauderdale, FLBuilt 2001 · S/N 228N65LJWorldwide Aircraft Services Inc · Tampa, FLBuilt 2001 · S/N 243N65LRConcorde Holdings LLC · Greenwood Village, COS/N 365N660CJBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 126N662ARJet Sales East LLC · El Paso, TXFirst renewal noticeBuilt 2001 · S/N 221N688DBParadise Aircraft LLC · Natchez, MSBuilt 1997 · S/N 097N696RBAti Jet Inc · El Paso, TXBuilt 1996 · S/N 075N696TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 250N69RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 321N707MRFast Eagle Corp · Coral Gables, FLBuilt 2001 · S/N 232N70LJWorldwide Aircraft Services Inc · Tampa, FLBuilt 1995 · S/N 070N711SEOso Aviation LLC · San Antonio, TXBuilt 2010 · S/N 376N714TSJet Connect LLC · Middletown, NYBuilt 2008 · S/N 340N716RPSolomon Mark Trustee · Wilmington, DEBuilt 1997 · S/N 095N719JBN719jb LLC · Las Vegas, NVBuilt 2005 · S/N 288N722BDLr60271 LLC · Wilmington, DES/N 271N723HCPonderosa Financial Services LLC · Salem, ORBuilt 2012 · S/N 420N732RJN732rj LLC · Miami Beach, FLBuilt 2011 · S/N 407N738RJBombardier LLC · North Palm Beach, FLBuilt 2011 · S/N 409N744RDWh Air LLC · Sanford, FLBuilt 1995 · S/N 053N74HTAmerican Jet International Corp · Houston, TXBuilt 2007 · S/N 324N754SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLS/N 054N770BZMaroon & Gold LLC · Albuquerque, NMBuilt 2005 · S/N 289N770XLjrsw LLC · Fort Myers, FLBuilt 2008 · S/N 60-336N772ECLearjet 60 G1 LLC · North Miami, FLS/N 257N772PPRsb Investments LLC · Washington, PABuilt 2005 · S/N 293N773SWJetlease LLC · Fargo, NDBuilt 2002 · S/N 254N783SASssi Inc · Canonsburg, PABuilt 2009 · S/N 368N787TSSidewinder Aviation LLC · Centennial, COBuilt 2008 · S/N 355N790SUPaper Airplanes 3 LLC · Scottsdale, AZBuilt 1998 · S/N 146
Back to AD 2012-08-16