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.

N822BDKoba LLC · Paradise Valley, AZBuilt 2005 · S/N 5064 N822SFGap Inc · San Francisco, CABuilt 2019 · S/N 5597 N824FMN824fm LLC · New York, NYBuilt 2011 · S/N 4222 N827ZFtfh LLC · Atlanta, GABuilt 2013 · S/N 5395 N830GRGwrg450 LLC · Atlanta, GABuilt 2012 · S/N 4259 N830NRCalico G550 LLC · North Miami, FLBuilt 2008 · S/N 5201 N837ZPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5393 N838KEDtc LLC · Newburgh, NYBuilt 2012 · S/N 5398 N83ML3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2014 · S/N 5470 N844CBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 4350 N844GFDiamond A Administration Company LLC · Dallas, TXBuilt 2009 · S/N 4160 N844SJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4281 N847RCRac Transcorp LLC · Lake Forest, ILBuilt 2011 · S/N 4215 N848JAD S Advisors Inc · Oak Park, ILBuilt 2004 · S/N 5047 N850LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 4036 N851WUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5342 N857GAPpg Industries Inc · West Mifflin, PABuilt 2019 · S/N 5596 N858KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5438 N85JMCook Canyon (Gp) LLC · Dallas, TXBuilt 2012 · S/N 5369 N85MXBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4228 N865JMDragonfly Holding LLC · Carmel, INBuilt 2007 · S/N 4078 N865RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5211 N866BBHff Xpressed LLC · Naples, FLBuilt 2014 · S/N 5466 N868BBBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 4051 N868BSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4080 N869DLN869dl LLC · Kansas City, MOBuilt 2006 · S/N 5136 N86ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5270 N86DQQdn Aviation LLC · New Canaan, CTBuilt 2014 · S/N 5489 N870CMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5076 N875TMTai Leasing Inc · Mckinney, TXBuilt 2015 · S/N 5526 N877SBSb Companies LLC · San Antonio, TXBuilt 2017 · S/N 5555 N878DBThorondor LLC · Palo Alto, CAFirst renewal noticeBuilt 2007 · S/N 5167 N878GCGraton Economic Development Authority · Rohnert Park, CABuilt 2003 · S/N 5025 N880SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5426 N882DEEco Aviation LLC · Coral Gables, FLBuilt 2011 · S/N 4233 N882PXNewage Aviation I LLC · Arcadia, CABuilt 2004 · S/N 5015 N882WRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5576 N883AFunair Corp · Aventura, FLBuilt 2007 · S/N 5175 N883SJBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 5279 N884SGRegistered aircraftBuilt 2011 · S/N 5319 N884WEKe O Mele Flight Co LLC · Santa Barbara, CABuilt 2008 · S/N 4143 N885AREssseaeff Aviation LLC · Jericho, NYBuilt 2008 · S/N 5224 N887MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5321 N887TMTai Leasing Inc · Mckinney, TXBuilt 2010 · S/N 5294 N888JELeone Management Inc · Camden, DEBuilt 2005 · S/N 5070 N888KZKz Partners Inc · Dover, DEBuilt 2010 · S/N 5309 N888LDJlssaa LLC · Foothill Ranch, CABuilt 2012 · S/N 5372 N888NDNpm Equipment Leasing LLC · Dallas, TXBuilt 2015 · S/N 4343 N888NSRegistered aircraftBuilt 2012 · S/N 5377 N88999Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 4362

Back to AD 2006-04-13 R1