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.

N805TMTai Leasing Inc · Mckinney, TXBuilt 2016 · S/N 6236 N808JGTwo Weeks Notice LLC · Miami Lakes, FLBuilt 2000 · S/N 598 N808LVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6152 N80ADArcadia Leasing LLC · Arcadia, WIBuilt 2016 · S/N 5539 N80PNBkf Aviation Ltd · Boston, MABuilt 1999 · S/N 576 N80TEBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 60006 N811TMTai Leasing Inc · Mckinney, TXBuilt 2017 · S/N 6281 N812RBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 5045 N817BCDelta Air Lines Inc · Atlanta, GAS/N 55171 N820BCDelta Air Lines Inc · Atlanta, GAS/N 55173 N820HBNasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1999 · S/N 570 N820MSSpeedero LLC · Hillsboro, ORBuilt 2000 · S/N 626 N82123Bank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 6344 N821SCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 5030 N822BDKoba LLC · Paradise Valley, AZBuilt 2005 · S/N 5064 N822VPVp LLC · Camden, DEBuilt 1999 · S/N 9016 N826BCHawaiian Airlines Inc · Honolulu, HIS/N 55183 N829ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6338 N82AUS Bank N A Trustee · Boston, MABuilt 2016 · S/N 6188 N82HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60028 N830NRCalico G550 LLC · North Miami, FLBuilt 2008 · S/N 5201 N835HCHood Capital LLC · Hattiesburg, MSBuilt 2017 · S/N 6292 N838SWAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1999 · S/N 9035 N83VPRegistered aircraftBuilt 2000 · S/N 614 N843GXAlesant Air LLC · Miami, FLBuilt 1999 · S/N 9026 N846CBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6269 N848JAD S Advisors Inc · Oak Park, ILBuilt 2004 · S/N 5047 N85DRegistered aircraftBuilt 2001 · S/N 9078 N85NVKhosla Ventures LLC · San Jose, CABuilt 1997 · S/N 513 N85VTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 595 N868KETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6272 N870CMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5076 N871FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 6304 N87WDWeeks-Davies Aviation Inc · West Palm Beach, FLBuilt 2001 · S/N 649 N882PXNewage Aviation I LLC · Arcadia, CABuilt 2004 · S/N 5015 N882WRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5576 N885KTJustifly LLC · Dallas, TXBuilt 2018 · S/N 6323 N886BCDelta Air Lines Inc · Atlanta, GAS/N 55191 N888HEGolden Sky Inc · Camden, DEBuilt 2001 · S/N 638 N888JELeone Management Inc · Camden, DEBuilt 2005 · S/N 5070 N889AHPasaca Capital Inc · Pasadena, CABuilt 1996 · S/N 512 N889CHPasaca Capital Inc · Pasadena, CABuilt 2015 · S/N 6118 N889KHInnova Aviation LLC · Pasadena, CABuilt 1998 · S/N 540 N890DACite Aviation LLC · Wilmington, DEBuilt 2005 · S/N 5079 N891ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55043 N892ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55044 N892BCDelta Air Lines Inc · Atlanta, GAS/N 55192 N892SSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6226 N893ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55045 N894ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55046

Back to AD 2009-07-01 R1