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.

N489FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 4360 N48PLLdp Aviation LLC · Sarasota, FLBuilt 2009 · S/N 4181 N494ECEastman Chemical Co · Kingsport, TNBuilt 2011 · S/N 4226 N495RSSugar Pine Aviation LLC · Merlin, ORBuilt 2006 · S/N 4049 N496GAGulfstream Aerospace Corporation · Savannah, GABuilt 2013 · S/N 4296 N497SBAdlaur Aviation LLC · St Thomas, VIBuilt 2009 · S/N 5238 N499SCFlying Ace LLC · Danville, CABuilt 2008 · S/N 4135 N4TDTeton Holdings II LLC · Chicago, ILBuilt 2006 · S/N 4044 N500GQIntellectual Air LLC · Atlanta, GABuilt 2010 · S/N 4191 N500RLBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4158 N501GMSc Transport LLC · Torrance, CABuilt 2017 · S/N 5561 N501QCQuikrete Aircraft Leasing LLC · Atlanta, GABuilt 2013 · S/N 5450 N503GSRegistered aircraftBuilt 2003 · S/N 5005 N503GVEmmanuel Group · North Wilkesboro, NCBuilt 2015 · S/N 5503 N504GTBengal Investments LLC · San Francisco, CABuilt 2008 · S/N 4149 N505DSwift Connections LLC · Los Angeles, CABuilt 2011 · S/N 5323 N506HGKimberly-Clark Integrated Services Corp · Dallas, TXBuilt 2012 · S/N 5400 N508CKIbc Hospitality LLC · Newport Beach, CABuilt 2007 · S/N 5158 N508WFTmw Aviation Partners LLC · Westport, CTBuilt 2008 · S/N 4142 N50SRegistered aircraftBuilt 2008 · S/N 5216 N50WHWhite Wing Holdings LLC · Waukegan, ILBuilt 2019 · S/N 5589 N510GTSouthwest Associates LLC · Bigfork, MTBuilt 2008 · S/N 5204 N510GVTtp Services LLC · Hillsborough, NCBuilt 2006 · S/N 5106 N510QSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5326 N512GVBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 5512 N512PMEbts LLC · New York, NYBuilt 2009 · S/N 4167 N512RJRegions Commercial Equipment Finance LLC · Birmingham, ALBuilt 2008 · S/N 4124 N513MARichport Air LLC · Miami, FLBuilt 2003 · S/N 5019 N516WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5516 N517DWColleen Corp · New Castle, DEBuilt 2013 · S/N 5417 N517TWGtw Corp · Jupiter, FLBuilt 2008 · S/N 5209 N518GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5618 N518GPG550 Msn 5051 Leasing LLC · Miami Beach, FLBuilt 2004 · S/N 5051 N518GSG S Transport Inc · San Antonio, TXBuilt 2016 · S/N 4353 N520CMOwl Hill Holdings LLC · Nashville, TNBuilt 2016 · S/N 4358 N521SBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 5199 N522GDL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5622 N523JMJmac Air LLC · Columbus, OHBuilt 2009 · S/N 4150 N524ACPegasus Leasing LLC · Ada, MIBuilt 2013 · S/N 5433 N524VEBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5424 N526EMEmi Travel LLC · Tampa, FLBuilt 2016 · S/N 5537 N526GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5626 N526SDWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5229 N527GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5627 N527JGGibbs International Inc · Spartanburg, SCBuilt 2005 · S/N 5067 N528APArrow Plane Lc · Provo, UTBuilt 2007 · S/N 5168 N529GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2021 · S/N 5629 N530GL3harris Technologies Flight Capital LLC Trustee · Greenville, TXBuilt 2021 · S/N 5630 N530PMEbts LLC · New York, NYBuilt 2004 · S/N 5031 N531GAL3harris Technologies Flight Capital LLC Trustee · Greenville, TXBuilt 2021 · S/N 5631

Back to AD 2006-04-13 R1