Registered aircraft · 726

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

N17ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 560-5030 N17EDExcel4 LLC · Carmel, INBuilt 2003 · S/N 560-5337 N17QSRegistered aircraftBuilt 2026 · S/N 560-6514 N1837STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 560-5155 N1853Bounty Investments LLC · Fort Worth, TXBuilt 2004 · S/N 560-5533 N1865KCommerce Bank · Kansas City, MOBuilt 2014 · S/N 560-6172 N1867MExcel Holdings LLC · Heber City, UTBuilt 2003 · S/N 560-5303 N189WWWindow World Inc · N Wilkesboro, NCBuilt 2000 · S/N 560-5069 N18GYFair Deal Leasing LLC · Omaha, NEBuilt 2006 · S/N 560-5600 N18JEPlanes Trains And Automobiles Inc · Hubertus, WIBuilt 1999 · S/N 560-5020 N18QSRegistered aircraftBuilt 2026 · S/N 560-6515 N18VFGriffco Air LLC · Kennesaw, GABuilt 2003 · S/N 560-5322 N1907MMeijer Distribution Inc · Grand Rapids, MIBuilt 2015 · S/N 560-6201 N1909MMark-It Consulting LLC · Lakehurst, NJBuilt 2004 · S/N 5605530 N196SBTexas Citation S II Management LLC · San Antonio, TXBuilt 2004 · S/N 560-5513 N1980MMaverick Aircraft Leasing LLC · North Little Rock, ARBuilt 2003 · S/N 560-5289 N19PPPpal Inc · Portage, MIBuilt 2023 · S/N 560-6352 N19QSRegistered aircraftBuilt 2026 · S/N 560-6516 N1KDDuncan Aviation Inc · Lincoln, NEBuilt 2006 · S/N 560-5648 N1MMN1mm LLC · Seattle, WABuilt 2006 · S/N 560-5669 N1PXC & C Aviation LLC · Worcester, MABuilt 2000 · S/N 560-5055 N2010FAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N 560-5208 N2022KMagnolia Air LLC · Adel, IABuilt 2002 · S/N 560-5260 N202ABArcbest II Inc · Fort Smith, ARBuilt 2024 · S/N 560-6364 N202RLDoc Sugar Master LLC · Daingerfield, TXBuilt 2000 · S/N 560-5117 N211CL10-2-4 Aviation LLC · Dallas, TXBuilt 2006 · S/N 560-5672 N211DDCatia Resources LLC · Garden City, TXBuilt 1999 · S/N 560-5022 N212CECal Enterprises LLC · Missoula, MTBuilt 2006 · S/N 560-5639 N212HFGopher Air LLC · New Richmond, WIBuilt 2015 · S/N 560-6190 N212LTTango Squared LLC · Fort Worth, TXBuilt 2012 · S/N 560-6124 N216BGBrasfield & Gorrie LLC · Birmingham, ALBuilt 2011 · S/N 560-6083 N21LHBda Air LLC · New Castle, DEBuilt 2009 · S/N 560-5822 N220BGBrasfield & Gorrie LLC · Birmingham, ALBuilt 2016 · S/N 560-6215 N220LERaythom LLC · Wilmington, DEBuilt 2001 · S/N 5605173 N220VPCjsmhc 1 LLC · Encinitas, CABuilt 2004 · S/N 560-5359 N221VPPicabo Leasing LLC · Picabo, IDBuilt 2004 · S/N 560-5363 N224JWSouthern Multifoods Inc · Jacksonville, TXBuilt 2012 · S/N 560-6120 N224KDK-D Leasing Inc · Scottsdale, AZBuilt 2002 · S/N 560-5261 N226JMLakeside Industries Inc · Issaquah, WABuilt 2016 · S/N 560-6208 N226SWNicklaus LLC · Bristol, VABuilt 2021 · S/N 560-6306 N227MCMatsco Inc · Wilmington, DEBuilt 2013 · S/N 560-6138 N227PXPaxair LLC · Phoenix, AZBuilt 2010 · S/N 560-6059 N227VCTexas Aircraft Lft LLC · Austin, TXBuilt 2013 · S/N 560-6150 N227VROneflight Jets Inc · Englewood, COBuilt 2002 · S/N 560-5227 N22QSRegistered aircraftBuilt 2026 · S/N 560-6518 N230DFVector Design Group LLC · Jeffersonville, INBuilt 2010 · S/N 560-6054 N233XLVanguard Jet LLC · Georgetown, TXBuilt 2002 · S/N 560-5233 N237EELes Schwab Warehouse Center Inc · Bend, ORBuilt 2013 · S/N 560-6149 N238SMExcel Leasing LLC · Excelsior, MNBuilt 2002 · S/N 560-5238 N239TCBombo Aviation LLC · Murrysville, PABuilt 2008 · S/N 560-5817

Back to AD 2012-06-01