Registered aircraft · 967

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:2018-07-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-13') 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:2018-07-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-13')
  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:2018-07-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-13')
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.

N221LCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 680-0228 N223PWCypress Healthcare LLC · Deer Lodge, MTBuilt 2010 · S/N 510-0314 N224JVVannoy Construction Aircraft LLC · Jefferson, NCBuilt 2025 · S/N 680A0438 N22EMPruett'S Food Inc · Broken Bow, OKBuilt 2007 · S/N 510-0047 N230PWJbs Inc · Wilmington, DEBuilt 2009 · S/N 510-0200 N234PHirschfeld David · Choteau, MTBuilt 2014 · S/N 510-0450 N23NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2014 · S/N 680-0527 N23SCTempest Aviation LLC · Dover, DEBuilt 2008 · S/N 680-0183 N23ZTTextron Aviation Inc · Wichita, KSS/N 680A0501 N242ASGreenhaven Securities LLC · Concord, CABuilt 2006 · S/N 680-0084 N246REWing Investments Fl LLC · Naples, FLBuilt 2010 · S/N 510-0295 N247DRUno Aviation LLC · El Paso, TXBuilt 2009 · S/N 510-0177 N247WSLynx Petroleum Consultants Inc · Hobbs, NMS/N 510-0204 N248LGCaribbean Flight Group LLC · Clearwater, FLBuilt 2011 · S/N 510-0311 N250ATEnvironmental Specialties International Inc · Baton Rouge, LABuilt 2006 · S/N 680-0075 N250CGCardinal Glass Industries Inc · Eden Prairie, MNBuilt 2020 · S/N 680A0250 N250CMHd Air LLC · Mercer, PABuilt 2007 · S/N 680-0170 N253CPPriceflight LLC · Louisville, KYBuilt 2004 · S/N 680-0010 N253TXJssi Parts LLC · Chicago, ILBuilt 2008 · S/N 680-0253 N254MBSrb Africa Holdings LLC · Pasadena, TXBuilt 2012 · S/N 680-0341 N255VGInternational Air Services Inc Trustee · Carson City, NVBuilt 2016 · S/N 680A0035 N258JLAir Jordan LLC · Newport News, VABuilt 2018 · S/N 680A0120 N259CAKansas LLC · Oklahoma City, OKBuilt 2014 · S/N 680-0505 N259CKAcuity Aviation LLC · Atlanta, GABuilt 2009 · S/N 680-0278 N25KNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 510-0112 N261AHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 680-0261 N262SJSdjc Assets LLC · Houston, TXBuilt 2008 · S/N 680-0175 N263PCBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 680A0154 N263TAPanorama Jets LLC · Dover, DEBuilt 2009 · S/N 680-0263 N26SQFreedom Air Flights LLC · Mohave Valley, AZBuilt 2007 · S/N 510-0031 N271CS105 Alas LLC · Del Mar, CABuilt 2009 · S/N 510-0158 N271PHMeridian Continuum LLC · Fort Lauderdale, FLBuilt 2007 · S/N 680-0151 N27369Textron Aviation Inc · Wichita, KSBuilt 2005 · S/N 712 N273TMWilmington Trust Co Trustee · Wilmington, DEBuilt 2024 · S/N 680A0411 N275BSBsav LLC · Moon Township, PABuilt 2015 · S/N 680A0007 N27DDDiamond D Aviation LLC · Sulphur, LABuilt 2009 · S/N 680-0267 N280AZRegistered aircraftBuilt 2008 · S/N 510-0061 N280PCessna Latitude 680a-0059 LLC · Wilmington, DEBuilt 2016 · S/N 680A0059 N282DA282da Amc LLC · Haviland, KSBuilt 2010 · S/N 510-0333 N284JSbsw22 LLC · Newark, DEBuilt 2006 · S/N 680-0105 N287LACarlito Air LLC · Sarasota, FLBuilt 2010 · S/N 510-0287 N288HKTranscendent Investments LLC · Wilsonville, ORBuilt 2011 · S/N 680-0313 N289KRTroy Equipment Holdings LLC · Houston, TXBuilt 2008 · S/N 6800193 N292JSJ.R. Simplot Company LLC · Boise, IDBuilt 2024 · S/N 680A0410 N293MMMk Leasing LLC · Scottsdale, AZBuilt 2010 · S/N 510-0293 N293TTRsbssh LLC · Indianapolis, INBuilt 2021 · S/N 680A0293 N295PJTes Turbine LLC · Creve Coeur, MOBuilt 2011 · S/N 510-0372 N29AGNutrien Ag Solutions Inc · Loveland, COBuilt 2006 · S/N 680-0100 N2CMBt Squared LLC · Amarillo, TXBuilt 2008 · S/N 510-0080 N2LPMmxii LLC · Chesapeake, VABuilt 2008 · S/N 680-0219

Back to AD 2018-07-13