Skip to content

AD 2006-04-13 R1

Registered aircraft · 671

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.

N889CJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5449 N889MSKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2008 · S/N 5190 N88AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 5337 N890DACite Aviation LLC · Wilmington, DEBuilt 2005 · S/N 5079 N892CHForeign Manufacturers Finance Corp · Wilmington, DEBuilt 2018 · S/N 5578 N895DAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5440 N898CETrans-Exec Air Service Inc · Van Nuys, CABuilt 2009 · S/N 5230 N899VTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5303 N8RMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5285 N8VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4161 N900ALTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 5500 N900CCWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 5501 N900JJetran LLC · Horseshoe Bay, TXS/N 5200 N900RHRite Hite Holding Corp · Milwaukee, WIBuilt 2015 · S/N 5507 N901GOwens Illinois General Inc · Swanton, OHBuilt 2009 · S/N 4163 N901XBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 5603 N903ASRegistered aircraftBuilt 2009 · S/N 5256 N904GBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 5101 N904JYB&D Aviation LLC · San Jose, CABuilt 2018 · S/N 5577 N906FSBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 5521 N906MMM6 Carson LLC · Las Vegas, NVBuilt 2008 · S/N 4136 N908CCTeton Trails LLC · Helena, MTBuilt 2010 · S/N 4195 N909ADDac Aviation LLC · Saratoga Springs, NYBuilt 2006 · S/N 5135 N913MKTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2007 · S/N 4075 N915TBBmc Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4039 N916VDCdr Capital LLC · Miami, FLBuilt 2015 · S/N 5509 N917CJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5399 N917GAPhoenix Esprit II LLC · Austin, TXBuilt 2011 · S/N 5317 N917VZKern Rene · Cleveland, OHBuilt 2017 · S/N 4364 N918CCAstor Street Asset Management Inc · Chicago, ILBuilt 2006 · S/N 4052 N918LBBva Operations LLC · Miami Beach, FLBuilt 2010 · S/N 4199 N918LLSienna Services Inc · Wilmington, DEBuilt 2009 · S/N 4177 N918WBChoice Administrators Insurance Services Inc · Orange, CABuilt 2005 · S/N 5072 N91GVAir Lake Lines IV Inc · Saint Paul, MNBuilt 2006 · S/N 4053 N91LAAviation Leasing Co LLC · New York, NYBuilt 2003 · S/N 5027 N926MB519sp LLC · Woodmere, NYBuilt 2008 · S/N 5197 N92709Ashla Equipment Holdings LLC · Dallas, TXBuilt 2014 · S/N 4315 N928GCWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5239 N928NJPeoples Choice Consulting LLC · Laguna Beach, CABuilt 2004 · S/N 5013 N92LABaxter Investment Company LLC · Morristown, NJBuilt 2003 · S/N 5002 N931DCCdt Ventures Group LLC · Riverside, CABuilt 2005 · S/N 4013 N933HHoneywell Aerospace US LLC · Phoenix, AZBuilt 2005 · S/N 5077 N940TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5198 N942JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 5487 N945TMAvpro Inc · Annapolis, MDBuilt 2005 · S/N 5086 N949FFPacifico 949 LLC · Dover, DEBuilt 2013 · S/N 5423 N949GMFour Fourteen Holdings LLC · Wilmington, DEBuilt 2006 · S/N 5120 N94JLBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4205 N94LFCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 5039 N95MJLfcm LLC · Dover, DEBuilt 2009 · S/N 5250

Back to AD 2006-04-13 R1