OpenAirDocs.org
AD 2007-12-21

Registered aircraft · 196

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-12-21')
    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-12-21')
  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.

N300SLAirsquid Aviation LLC · Las Vegas, NVS/N RB-110N311SQJb&B Capital LLC · Knoxville, TNBuilt 2001 · S/N RB-5N313SJEmerald City Travel LLC · Wake Forest, NCS/N RB-30N319BYRegistered aircraftBuilt 2005 · S/N RB-131N322BJBank Of Utah Trustee · Salt Lake City, UTS/N RB-93N323KMKirkendoll Management LLC · New Orleans, LABuilt 2009 · S/N RB-270N32SGBank Of Utah Trustee · Salt Lake City, UTS/N RB-90N330ACLexair LLC · Mangonia Park, FLBuilt 2007 · S/N RB-173N333JKPremier Rb-159 LLC · Wilmington, DEBuilt 2006 · S/N RB-159N354RBD&J Air LLC · Canyon, TXBuilt 2002 · S/N RB-54N365ALHigh Limits II LLC · Fort Lauderdale, FLBuilt 2008 · S/N RB-261N368CCS & J Aviation LLC · Sioux Falls, SDBuilt 2007 · S/N RB-184N368CSTri Cities Air LLC · Las Vegas, NVBuilt 2008 · S/N RB-234N3725LSabino Holdings LLC · Fort Wayne, INS/N RB-155N372BWBirdseye Holding LLC · Phoenix, AZBuilt 2005 · S/N RB-130N373MMLa Hawk Holding Co LLC · Fort Worth, TXBuilt 2008 · S/N RB-237N380SADs Air Holdings LLC · Monsey, NYS/N RB-139N390ABBenair LLC · Las Vegas, NVBuilt 2008 · S/N RB240N390BDZero Bravo Delta Holdings LLC · Lewes, DEBuilt 2007 · S/N RB-193N390CEN390ce LLC · Davie, FLBuilt 2002 · S/N RB-40N390GMBlack Bear Investment Holdings Inc · Naples, FLBuilt 2006 · S/N RB-172N390HFHei Aviation LLC · Powell, OHS/N RB-170N390HGVelocitas Ventures LLC · Fitchburg, WIBuilt 2011 · S/N RB-283N390KStmo Av LLC · Little Rock, ARS/N RB-225N390MBSantana Trading LLC · Edinburg, TXBuilt 2001 · S/N RB-21N390MLSouthern Nevada Oral & Maxillofacial Surgery LLC · Las Vegas, NVS/N RB-142N390MMLyon Flyon LLC · Scottsdale, AZBuilt 2009 · S/N RB-266N390PTAstronics Air II LLC · East Aurora, NYS/N RB-135N390SAExecutive Air Taxi Corp · Bismarck, NDBuilt 2007 · S/N RB-204N390SMRk Aero LLC · Sioux Falls, SDBuilt 2002 · S/N RB-36N390XXPikeville Premier Aero LLC · Pikeville, KYS/N RB-289N391YSInfineon Aviation II LLC · Dallas, TXBuilt 2001 · S/N RB-6N39JCSkyline Enterprises Corp · Miramar, FLS/N RB-61N39RPInsar USA Corp · Wilmington, DEBuilt 2003 · S/N RB-77N3KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N RB-218N404JMPj1 LLC · Fishers, INS/N RB-167N40JDNup Aviation LLC · Princeton, ILS/N RB-35N410SHSilverton Air LLC · Bardstown, KYBuilt 2008 · S/N RB-251N414TELaz Air LLC · Hartford, CTBuilt 2001 · S/N RB-4N415HDPremier 1 Partners LLC · Scottsdale, AZBuilt 2004 · S/N RB86N419BRBoardroom Aviation LLC · Washoe Valley, NVBuilt 2008 · S/N RB-257N42ELPrevailing Winds LLC · Sellersburg, INS/N RB-145N42SCKana Hotels Inc · Knoxville, TNBuilt 2007 · S/N RB-212N43GGPointe Wiregrass Inc · Dothan, ALBuilt 2007 · S/N RB-160N441RF441rf LLC · Loomis, CABuilt 2007 · S/N RB-182N444ESSammbie LLC · Georgetown, KYS/N RB-113N451KTLvp Jet Fleet LLC · Wilmington, DEBuilt 2003 · S/N RB-74N452KTDac Aviation Holdings LLC · Camden, DEBuilt 2004 · S/N RB-118N462CBC & B LLC · Burbank, CAS/N RB-136N46CKRb163 LLC · Tyler, TXS/N RB-163
Back to AD 2007-12-21