Registered aircraft · 999

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:2007-03-17-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:2007-03-17-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:2007-03-17-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:2007-03-17-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:2007-03-17-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:2007-03-17-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.

N756TWKehl Rd LLC · Sixes, ORBuilt 2009 · S/N 519 N759XTBte Investments LLC · Howell, MIBuilt 2010 · S/N 554 N75BSPpsp LLC · Palo Alto, CABuilt 2015 · S/N 1067 N75BTAbide Aviation LLC · Wilmington, DES/N 29 N75MATriple T Aviation LLC · Wilmington, DEBuilt 2025 · S/N 1614 N762RSSa Leasing LLC · Newark, DES/N 199 N767HPBarringer Aviation LLC · Waxhaw, NCBuilt 1999 · S/N 152 N769JSSpurlock Benjamin · Eugene, ORBuilt 2001 · S/N 187 N770DCRam Aviation LLC · Alexandria, LABuilt 2000 · S/N 183 N770TTStatewide Management Services Inc · Marion, INS/N 1640 N772AM2020 Aviation LLC · Wayne, PABuilt 2018 · S/N 1224 N772KHKish Aviation LLC · Meridian, IDBuilt 2000 · S/N 168 N772WWL39 LLC · Far Hills, NJBuilt 2014 · S/N 1010 N774AWTas320 LLC · Missoula, MTBuilt 2012 · S/N 628 N775CETransatlantic Deliveries Trust · Wilmington, DES/N 1676 N776RMPclb Aviation LLC · Idaho Falls, IDS/N 98 N777FXLcg One LLC · San Diego, CABuilt 2004 · S/N 294 N777TAJuliet Whiskey Aviation LLC · Sunny Isles Beach, FLBuilt 2022 · S/N 1430 N777XASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2013 · S/N 680 N7790JTbm-1077 LLC · Diamond Point, NYBuilt 2015 · S/N 1077 N77LGFly High Line LLC · Shelby, OHBuilt 2003 · S/N 267 N783BBAltura Air LLC · West Barnstable, MABuilt 2013 · S/N 677 N785MAAircraft Rental Services Inc · Escanaba, MIBuilt 2003 · S/N 280 N788RBFlight Levels LLC · Evergreen, COBuilt 2007 · S/N 395 N788RRNaquin Precision Earth Moving Inc · Yuma, AZBuilt 2000 · S/N 167 N790CABig Air Productions Of Fl LLC · Niceville, FLBuilt 2005 · S/N 341 N790MCMccracken Holdings LLC · Fort Worth, TXBuilt 2007 · S/N 409 N790TBKnights Aviation LLC · Kirkland, WABuilt 1999 · S/N 148 N795NDMancuso Aviation Of Oyster Bay LLC · Oyster Bay, NYBuilt 2018 · S/N 1241 N7SASla-Flyer LLC · Steamboat Springs, COBuilt 2005 · S/N 322 N7WNN44wn LLC · Silver City, NMBuilt 2023 · S/N 1480 N805MKParamount Holdings LLC · Eugene, ORBuilt 2024 · S/N 1534 N806LRGraystone Pearl Holdings LLC · Newark, DEBuilt 2025 · S/N 1595 N8083Magnum Air LLC · West Fargo, NDBuilt 2013 · S/N 678 N808JWGriffin David · Houston, TXBuilt 2014 · S/N 1007 N809MCJmc Communities I LLC · Saint Petersburg, FLBuilt 2013 · S/N 651 N80RARodriguez & Associates Plc · Bakersfield, CABuilt 2023 · S/N 1489 N810DSD&S Electrical Contractors Inc · Clarkston, WABuilt 2018 · S/N 1267 N813GGTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2017 · S/N 1196 N814TRFour Tango Romeo LLC · Sheridan, WYBuilt 2025 · S/N 1615 N815KInterstate Air LLC · Saint Louis, MOBuilt 2014 · S/N 1025 N815RDDietrich Richard C · Cleveland Heights, OHS/N 338 N816FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 1578 N817HFHubbard James D Jr · Fort Worth, TXBuilt 2012 · S/N 609 N819LMAer 1121 LLC · Naples, FLBuilt 2013 · S/N 675 N81MJMorrow Aviation LLC · Midland, TXBuilt 2003 · S/N 265 N81YYAircraft Partner Holdings Inc Trustee · BerlinBuilt 2016 · S/N 1154 N823KKKemna Aviation LLC · North Fort Myers, FLBuilt 2025 · S/N 1583 N828DDN828dd LLC · Klamath Falls, ORBuilt 2016 · S/N 1148 N82CDSpentone Aviation LLC · Wilmington, DEBuilt 2023 · S/N 1500

Back to AD 2007-03-17 R1