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.

N1007SNmaer Inc · Orlando, FLBuilt 2007 · S/N RB-209N100WEHw Aviation LLC · Shepherdsville, KYS/N RB-45N110PRCrown Air LLC · Bend, ORBuilt 2002 · S/N RB-29N122DSDiamond A Aviation LLC · Amarillo, TXS/N RB-100N134SWSugar Woods Family Aviation LLC · Shreveport, LAS/N RB-81N138SJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N RB-138N143QCKeystone Senior Ac LLC · North Miami, FLBuilt 2004 · S/N RB-114N145JSWms Aviation LLC · Las Vegas, NVS/N RB-119N166ANValiair Lc Trustee · Casper, WYBuilt 2008 · S/N RB-227N167DPRgv Sky LLC · Harlingen, TXBuilt 2003 · S/N RB-67N176CRNs Aviation Corp · Malibu, CABuilt 2006 · S/N RB-154N1777TRegistered aircraftN-number assigned (import), not yet registeredS/N RB-215N178CFRb-178 LLC · Buffalo, NYBuilt 2007 · S/N RB-178N17CNFlying Blue LLC · Las Vegas, NVS/N RB-121N183DTChameleon Aviation LLC · Fort Worth, TXS/N RB-116N189KBibg2 LLC · Georgetown, KYBuilt 2008 · S/N RB-248N193CSCsoki Aviation Inc · Knoxville, TNS/N RB-115N199RMSmg Starfire LLC · Carson City, NVS/N RB-99N19KMAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2004 · S/N RB-83N19MFSky Solutions LLC · Detroit, MIBuilt 2001 · S/N RB-19N1EGLevenson Louis · Atlanta, GABuilt 2002 · S/N RB-43N1JRSolomon Mark Trustee · Wilmington, DEBuilt 2009 · S/N RB-268N1SHLux 11 Holdings LLC · Tuscola, TXS/N RB-117N1XHN173pl Leasing LLC · Texarkana, ARS/N RB-76N1XTRb171 LLC · Wilmington, DES/N RB-171N200PRDodson International Parts Inc · Rantoul, KSS/N RB-79N200STLilly Factor LLC · Jupiter, FLBuilt 2005 · S/N RB-102N203BPTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2007 · S/N RB-203N207AHTwo J'S Aviation LLC · Fort Wayne, INBuilt 2007 · S/N RB-207N208MMHeartland Aviation LLC · Ada, OKBuilt 2008 · S/N RB-232N210ERValiair Ltd Co Trustee · Casper, WYBuilt 2009 · S/N RB-258N213BCBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N RB-288N213VU213vu Inc · Dover, DES/N RB-197N215BDCbms Inc · Wilmington, DES/N RB-183N21FMRcs Holdings LLC · Cross Lanes, WVBuilt 2009 · S/N RB-273N21XPBroad Street Aviation LLC · Columbus, OHBuilt 2001 · S/N RB-9N22VKPremier 1abmp LLC · Henderson, NVS/N RB-140N230ECEg Aviation LLC · Canton, OHS/N RB-59N230WPNo Worries Aviation LLC · Winston Salem, NCBuilt 2009 · S/N RB-267N23CGKing Enterprises Of Destin LLC · Miramar Beach, FLBuilt 2010 · S/N RB-277N23FTProtech Industries LLC · Great Falls, MTBuilt 2009 · S/N RB-275N23FWMiller Waste Mills Inc · Winona, MNS/N RB-133N23HDZ&K Aviation LLC · Liberty, MOBuilt 2009 · S/N RB-272N255PXTrans Equipment Services LLC · Wilmington, DES/N RB-189N25MCNarc LLC · Tyler, TXS/N RB-49N264DLBaron Air LLC · Camp Hill, PABuilt 2002 · S/N RB-27N273KTVentura Air LLC · Atlanta, GABuilt 2006 · S/N RB-151N282DFFugate Enterprises LLC · Wichita, KSBuilt 2010 · S/N RB-282N286EBEcho Bravo Aviation I LLC · Wilmington, DEBuilt 2011 · S/N RB-286N28JVDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2004 · S/N RB-97
Back to AD 2007-12-21