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.

N305LMHga LLC · Dallas, TXBuilt 2001 · S/N 1443 N306MASc Aviation LLC · Austin, TXBuilt 2007 · S/N 9225 N3131A313 Aviation Holdings LLC · Miami Beach, FLBuilt 2003 · S/N 5021 N313RGRenair 650 LLC · New York, NYBuilt 2017 · S/N 6262 N316FSea To Sea Aviation LLC · Dallas, TXBuilt 2003 · S/N 5007 N316VAAvation LLC · Grand Rapids, MIBuilt 2015 · S/N 5530 N318LSRegistered aircraftBuilt 2016 · S/N 6204 N319GGGg Aviation LLC · San Luis Obispo, CABuilt 2000 · S/N 9070 N319PEPlus3 Aviation LLC · West Hollywood, CABuilt 2016 · S/N 6219 N3251KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6192 N325APTalaria Logistics LLC · Denver, COBuilt 2017 · S/N 6276 N329SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6224 N330KCRegistered aircraftBuilt 2013 · S/N 9579 N333GWBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6099 N336EBJ C Flowers & Co LLC · New York, NYBuilt 2015 · S/N 5525 N336LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2000 · S/N 5081 N337LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2007 · S/N 5099 N340FLHines Hill Aviation LLC · Boston Heights, OHBuilt 2000 · S/N 612 N342ZKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6135 N34HSHs Arrow LLC · Indianapolis, INBuilt 2015 · S/N 5514 N351LSCombined Aircraft Ownership LLC · Fargo, NDBuilt 2000 · S/N 9050 N358VUS Bank Na · Marshall, MNBuilt 2015 · S/N 6161 N363JGIrongate Air LLC · Los Angeles, CABuilt 2000 · S/N 594 N365BFN365bf LLC · New York, NYBuilt 1998 · S/N 544 N365CJTashi Corp · Oakland, CABuilt 2000 · S/N 9077 N365LVAult Aviation LLC · Las Vegas, NVBuilt 2005 · S/N 5094 N36GVRegistered aircraftBuilt 2002 · S/N 674 N36MMJags Leasing LLC · Piscataway, NJBuilt 2007 · S/N 9244 N372BCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9413 N37LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 9164 N37NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2018 · S/N 5580 N38NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2015 · S/N 5527 N3LBStellas Taxi LLC · Tampa, FLS/N 6123 N3LLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5080 N400BCBall Corp · Broomfield, COBuilt 2013 · S/N 9573 N405LABank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 5574 N415DSNexa Aviation LLC · Burlingame, CAS/N 5090 N416ELC2 Aviation II LLC · Carson City, NVBuilt 2018 · S/N 6330 N417LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60004 N420JGDuval Investments LLC · Southfield, MIBuilt 2002 · S/N 667 N421ALWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 9051 N427HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 662 N444DHHatley Aviation LLC · Johnson City, TNBuilt 2005 · S/N 5084 N446CCD&Tc LLC · Carlsbad, NMBuilt 2016 · S/N 6238 N459BEAdsum LLC · Dallas, TXBuilt 1998 · S/N 541 N459BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6321 N469RRLegacy Aviation Inc · Camden, DEBuilt 2004 · S/N 5055 N470BBReina Capital LLC · Miami, FLBuilt 2004 · S/N 9150 N472USU S Department Of Homeland Security · Arlington, VABuilt 2016 · S/N 6198 N473USU S Department Of Homeland Security · Arlington, VABuilt 2016 · S/N 6242

Back to AD 2009-07-01 R1