Skip to content

AD 2009-07-01 R1

Registered aircraft · 519

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:2009-07-01-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:2009-07-01-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:2009-07-01-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:2009-07-01-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:2009-07-01-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:2009-07-01-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.

N1964MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 5558 N1989Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 9039 N1AMMeruelo Group LLC · Downey, CABuilt 2000 · S/N 623 N1BBBollinger Enterprises LLC · New Orleans, LABuilt 2001 · S/N 660 N1DCBlue Star Management Services Corp · Frisco, TXBuilt 2001 · S/N 651 N1HCHardesty-Gulfstream LLC · Tulsa, OKBuilt 2003 · S/N 5009 N1NKBase Aviation LLC · Jupiter, FLBuilt 2015 · S/N 5534 N1PGProcter & Gamble Leasing LLC · Cincinnati, OHBuilt 2017 · S/N 6260 N2000STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6133 N203BHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 60184 N20RCBristol Air LLC · Missoula, MTBuilt 2017 · S/N 6300 N215BBBl Charter LLC · Pittsfield, MABuilt 2000 · S/N 610 N219GXCmc 9256 LLC · Lewes, DEBuilt 2007 · S/N 9256 N220FBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 9011 N222LXTrans Exec Air Service Inc · Van Nuys, CABuilt 2001 · S/N 633 N225ELThesun LLC · Miami, FLBuilt 1999 · S/N 587 N226SJSsc Asset Co II LLC · Irvine, CABuilt 2001 · S/N 9095 N226SLSpencer Talia Aviation LLC · Los Angeles, CABuilt 2001 · S/N 628 N228ZDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6126 N229KMMike Post Productions Inc · Burbank, CABuilt 1996 · S/N 504 N22TRegistered aircraftBuilt 2015 · S/N 6151 N230BDGlobal Pursuits LLC · New York, NYBuilt 2006 · S/N 5115 N2320Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60008 N235BHHamilton Aviation Inc · Portland, ORBuilt 2016 · S/N 6222 N237GAOrange County/Sunbird Aviation LLC · Costa Mesa, CABuilt 2015 · S/N 5523 N239GACentury Aviation International Inc · Wilmington, DEBuilt 1997 · S/N 517 N239MJG4sp Holdings LLC · West Palm Beach, FLBuilt 2005 · S/N 5095 N23DCRegistered aircraftBuilt 2017 · S/N 6287 N23UCBay Equipment LLC · Miami, FLBuilt 2000 · S/N 9064 N241CETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6310 N245TTWotan America Inc · Fort Lauderdale, FLBuilt 2003 · S/N 5003 N256CWSrit LLC · Irvine, CABuilt 1998 · S/N 547 N25CPWilmington Trust Co Trustee · Wilmington, DEBuilt 1997 · S/N 527 N25GVEast Coast Brokerage Services LLC · West Palm Beach, FLBuilt 1999 · S/N 591 N25HLWilmington Trust Company Trustee · Wilmington, DEBuilt 2005 · S/N 5066 N267WAGlobal Aircraft LLC · Eden Prairie, MNBuilt 2000 · S/N 622 N270LEDtaa LLC · Dallas, TXBuilt 2015 · S/N 6164 N271GLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 9134 N27RARadz Air II LLC · El Segundo, CABuilt 1998 · S/N 543 N283PHGlobal Services Detroit LLC · Detroit, MIBuilt 2015 · S/N 5505 N285PHGlobal Services Detroit LLC · Detroit, MIBuilt 2015 · S/N 5522 N298ALBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 6342 N2JWJw Air LLC · Houston, TXBuilt 2011 · S/N 9461 N2NBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 6298 N2PGProcter & Gamble Leasing LLC · Cincinnati, OHBuilt 2017 · S/N 6264 N2QEBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 9629 N2TN2t Inc · Hillsboro, ORBuilt 2005 · S/N 9162 N302SBSchell Brothers II LLC · Rehoboth Beach, DEBuilt 2003 · S/N 5026 N302TRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6259 N303BDFjb 16720 LLC · The Woodlands, TXBuilt 2004 · S/N 5058

Back to AD 2009-07-01 R1