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.

N777JFIntrapack Industries Inc · Dallas, TXS/N RB105N778KGator Aviation LLC · Indianapolis, INBuilt 2007 · S/N RB-206N784MASien Air LLC · Missoula, MTS/N RB-141N784PCCarlyle Air LLC · Morristown, TNS/N RB-166N79CBLovell Equity LLC · Phoenix, AZBuilt 2008 · S/N RB-264N7TXCason Aviation LLC · Abilene, TXBuilt 2007 · S/N RB-198N808CSSierra Alpha Aviation LLC · Brookings, SDS/N RB-62N808LFrank Fletcher Premier Two LLC · Sherwood, ARBuilt 2008 · S/N RB-244N808SQFinal Approach Investments LLC · Smithville, MOBuilt 2003 · S/N RB78N80VRValor Jets Inc · Osprey, FLBuilt 2001 · S/N RB-7N810WTAarl Services LLC · White Pigeon, MIS/N RB-122N815SFRegistration Pending · Lighthouse Point, FLRegistration pendingBuilt 2008 · S/N RB-250N817WCollier Air LLC · Sioux Falls, SDS/N RB-107N81HRTres Aguilas LLC · Edinburg, TXBuilt 2007 · S/N RB-200N833PSPremier Aircraft Trading Services Inc · Lewes, DEBuilt 2002 · S/N RB-18N835ZTZotec Aviation LLC · Carmel, INBuilt 2007 · S/N RB-180N84VAA Street LLC · Saint Paul, MNS/N RB-134N851TMCellular Sales Aviation Of Tennessee II LLC · Knoxville, TNBuilt 2007 · S/N RB-211N855JBGeorge Inc · Wilmington, DES/N RB104N858QOcpx LLC · Pray, MTBuilt 2009 · S/N RB-269N85PLPremier Wings LLC · Portland, ORS/N RB-55N865RMFusebox LLC · Alcoa, TNBuilt 2011 · S/N RB-287N888MNFlying Moose LLC · Prescott, AZS/N RB-153N88ERPremier 1 Aviation LLC · Evansville, INBuilt 2002 · S/N RB-17N88MMCraig Air LLC · Scottsdale, AZS/N RB-44N8PJFaith Life International Inc · Sarasota, FLS/N RB-69N903MTSouthern Star Holdings LLC · Safety Harbor, FLBuilt 2001 · S/N RB-24N929SSGmn Joint Air LLC · Dexter, MOS/N RB-15N92SHCoffman Air LLC · Liberty, INBuilt 2002 · S/N RB-33N936JGN936jg LLC · Las Vegas, NVBuilt 2008 · S/N RB-246N93JCSolomon Mark Trustee · Wilmington, DEBuilt 2010 · S/N RB-280N946LCD Fla Aviation LLC · Huntsville, TNBuilt 2007 · S/N RB-205N952GLRio Bravo Helicopters Corp Aka · Laredo, TXBuilt 2007 · S/N RB-213N952SPPremier Jet Air LLC · Adel, GABuilt 2008 · S/N RB-260N956MCMichael Cowen Equipment Leasing LLC · San Antonio, TXBuilt 2005 · S/N RB-169N957RDTailwind Aviation Llp · Bismarck, NDBuilt 2001 · S/N RB-8N95JCSkyline Aviation Services LLC · Miramar, FLS/N RB-233N964TSHsi Aviation LLC · Wichita, KSS/N RB-129N969RE390 LLC · Las Vegas, NVFirst renewal noticeBuilt 2002 · S/N RB-14N972PFAviation Capital Partners LLC · Camden, DEBuilt 2002 · S/N RB-38N991MLN991ml LLC · Baxley, GABuilt 2008 · S/N RB-254N992SCTerrajet Holdings LLC · Louisville, KYBuilt 2007 · S/N RB-191N9930BRegistration Pending · Gig Harbor, WARegistration pendingBuilt 2008 · S/N RB-241N99BCEcho Pop Aviation LLC · Yarmouth, MEBuilt 2008 · S/N RB-242N99WJBgd&S Capital Holdings LLC · Dunedin, FLS/N RB-52N9LVMike Lima LLC · Los Angeles, CAS/N RB-132
Back to AD 2007-12-21