Skip to content

AD 2006-04-13 R1

Registered aircraft · 672

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

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:2006-04-13-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-04-13-R1') ORDER BY n_number

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

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:2006-04-13-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-04-13-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N321SDN321sd Inc · Melbourne, FLBuilt 2013 · S/N 5420 N323MKMkre Equipment LLC · Coral Gables, FLBuilt 2007 · S/N 4077 N325CTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5401 N325HQSunset Harbour Consulting LLC · Miami Beach, FLBuilt 2012 · S/N 5391 N329HFHr Leasing LLC · Dover, DEBuilt 2007 · S/N 4108 N32TMJmt II LLC · Glenview, ILS/N 4196 N33055Maybach Air LLC · Davie, FLBuilt 2012 · S/N 5407 N332PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5283 N333DSAdc Holdings LLC · Manteca, CABuilt 2010 · S/N 5292 N333EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5220 N336EBJ C Flowers & Co LLC · New York, NYBuilt 2015 · S/N 5525 N336LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2000 · S/N 5081 N337LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2007 · S/N 5099 N338LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2000 · S/N 5150 N339ETTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4295 N339JMHd Landing LLC · Dover, DEBuilt 2007 · S/N 5178 N339LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2007 · S/N 5166 N33LVMd Air LLC · Wilmington, DEBuilt 2014 · S/N 4316 N344RSU S Bank Na Trustee · Hartford, CTBuilt 2013 · S/N 5444 N345LCN276gc LLC · Carlsbad, CABuilt 2007 · S/N 5145 N34HSHs Arrow LLC · Indianapolis, INBuilt 2015 · S/N 5514 N350GDGulfstream Leasing LLC · Savannah, GABuilt 2005 · S/N 4023 N353LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5519 N35AAAltitude Aviation Group LLC · Irvine, CABuilt 2011 · S/N 5291 N35DMArcadian Leasing LLC · Gary, INBuilt 2011 · S/N 4231 N35GRWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 5183 N360BEPotomac Air LLC · Bethesda, MDBuilt 2006 · S/N 4054 N365LVAult Aviation LLC · Las Vegas, NVBuilt 2005 · S/N 5094 N366WWVeritaire LLC · Coral Gables, FLBuilt 2004 · S/N 5032 N369GAGulfstream Aerospace Corp · Savannah, GAS/N 4369 N370GAGulfstream Aerospace Corp · Savannah, GAS/N 4370 N371JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5304 N377SAAdams Office LLC · Southbury, CTBuilt 2007 · S/N 5155 N37JLLeprino Foods Co · Denver, COBuilt 2009 · S/N 4162 N37NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2018 · S/N 5580 N383KKWestern Devcon Inc · San Diego, CABuilt 2012 · S/N 4252 N388ACA C Travel LLC · Palm Beach, FLBuilt 2006 · S/N 5125 N388GCWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 5336 N38NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2015 · S/N 5527 N393VFArrow 393 LLC · New York, NYBuilt 2008 · S/N 5205 N39FMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5412 N3LLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5080 N400CRComstock Resources Inc · Frisco, TXBuilt 2008 · S/N 5213 N401JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4286 N401SRGulfstream Leasing LLC · Savannah, GABuilt 2003 · S/N 4001 N402JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 4266 N405CBNevada Global Jet LLC · Henderson, NVBuilt 2007 · S/N 5156 N405LABank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 5574 N407DWP A T Productions Aviation LLC · Severna Park, MDBuilt 2006 · S/N 4050 N407GKBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 5068

Back to AD 2006-04-13 R1