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.

N700MKWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 6319 N700YBYb Global LLC · Mequon, WIBuilt 2010 · S/N 9377 N703RKEmergence Southwest LLC · Jacksonville, FLBuilt 2002 · S/N 671 N704MFMc Group · Santa Monica, CABuilt 1999 · S/N 9065 N708DSWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 6285 N709AABank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 635 N70PSRi Mercury LLC · Beverly, MABuilt 1999 · S/N 9012 N711MCN&Md Investment Corp · Missoula, MTBuilt 2002 · S/N 9121 N717JLDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 55042 N718DDFlt 2 LLC · Dallas, TXBuilt 2004 · S/N 9140 N718JJJj Acquistions 681 LLC · Secaucus, NJBuilt 2002 · S/N 681 N718MCRadical Ventures LLC · Dallas, TXBuilt 2004 · S/N 5061 N720LETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6197 N721AZSz Aviation LLC · Miami, FLBuilt 1999 · S/N 565 N721MCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 691 N721MMMandalay Resort Group LLC · Las Vegas, NVBuilt 2018 · S/N 6332 N721MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 9695 N721RHRh · Wilmington, DEBuilt 2003 · S/N 5010 N724JJKoga Air LLC · San Luis Obispo, CABuilt 2009 · S/N 9357 N726BFWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 9268 N730BCDelta Air Lines Inc · Atlanta, GAS/N 55176 N73RPTransportation Holdings IV LLC · Dallas, TXBuilt 2015 · S/N 5528 N740SS740ss LLC · Tooele, UTBuilt 1997 · S/N 532 N750LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 5096 N757RRDirectional Capital LLC · Cleveland, OHBuilt 2016 · S/N 6213 N75CCNbi LLC · New Bremen, OHBuilt 2005 · S/N 5065 N765ATSapphire No5 LLC · Westlake Village, CABuilt 2004 · S/N 5063 N766PSPts Air LLC · Richmond Heights, OHBuilt 1997 · S/N 509 N767CWN767cw LLC · Camden, DEBuilt 1997 · S/N 520 N769WECd 321 LLC · Austin, TXBuilt 2004 · S/N 5048 N776MAGlf5 629 LLC · Wilmington, DEBuilt 2001 · S/N 629 N776RBFlower In The Field Av LLC · Santa Monica, CABuilt 1999 · S/N 585 N777ZHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6240 N778ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6289 N77NZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 9144 N780KSMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2005 · S/N 5091 N780WGulfstream Gv-530 LLC · Wilmington, DEBuilt 1997 · S/N 530 N786JMPated LLC · Wilmington, DEBuilt 1999 · S/N 502 N786NMCd 321 LLC · Austin, TXBuilt 1997 · S/N 522 N787GPMalibu Consulting Corp · Beverly Hills, CABuilt 2001 · S/N 655 N789LRNordlys LLC · Bedford, NHBuilt 2006 · S/N 5100 N79999Bank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 6256 N799BCDelta Air Lines Inc · Atlanta, GAS/N 55170 N79AYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 9058 N7HARegistered aircraftBuilt 2015 · S/N 6172 N7SESteven Brothers Aviation LLC · Wichita, KSBuilt 2005 · S/N 5088 N800JHJ&J Aviation LLC · Crested Butte, COBuilt 2005 · S/N 5073 N801ASRegistered aircraftBuilt 2005 · S/N 5097 N801PNSabrina Aviation Corp · Boston, MABuilt 2000 · S/N 9062 N803HHHogs Head Air III LLC · New York, NYBuilt 2002 · S/N 665

Back to AD 2009-07-01 R1