Skip to content

Registered aircraft · 225

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

N108WWeyerhaeuser Nr Co · Eugene, ORBuilt 1993 · S/N 52034 N10XVHelicopters Inc · Wilmington, DEBuilt 2004 · S/N 52293 N114SFN179sf LLC · Chandler, AZBuilt 1995 · S/N 52154 N11TVHelicopters Inc · Cahokia, ILBuilt 2004 · S/N 52289 N121LPPremier Rotors LLC · Saint Martinville, LABuilt 1996 · S/N 52177 N12AAAllsouth Aviation LLC · Buford, GABuilt 1996 · S/N 52165 N12BQHelicopters Inc · Cahokia, ILBuilt 1993 · S/N 52012 N12JWRuffwood Inc · Atlanta, GABuilt 1997 · S/N 52193 N131WMWestwind Helicopters Inc · Santa Fe, TXBuilt 2005 · S/N 52311 N137MMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2009 · S/N 52396 N13HDHelicopters Inc · Wilmington, DEBuilt 1995 · S/N 52152 N13NNHelicopters Inc · Wilmington, DEBuilt 2008 · S/N 52380 N146SPSamaritan'S Purse · Boone, NCBuilt 2000 · S/N 52243 N157PAPatriot Aviation Inc · Greenville, DEBuilt 2003 · S/N 52241 N161SFGm Leasing Co LLC · Broussard, LABuilt 2006 · S/N 52335 N164AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52494 N165AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52495 N166AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52496 N169RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52063 N173MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2000 · S/N 52256 N173RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52066 N175MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2006 · S/N 52326 N179RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52102 N17TWWhirlybird Aviation LLC · Bend, ORBuilt 1998 · S/N 52213 N1807Gm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 52361 N1821Gm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 52366 N192RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1996 · S/N 52192 N193ALBlade Leasing LLC · Homer, AKBuilt 2006 · S/N 52344 N1957ZDakota Rotors LLC · Custer, SDBuilt 1994 · S/N 52109 N19BHAbc Helicopters Inc · Jefferson, WIBuilt 2008 · S/N 52370 N1AKMeridian Investments LLC · Anchorage, AKBuilt 2005 · S/N 52317 N1TNNorman Family Investments LLC · Greenville, TXBuilt 1993 · S/N 52031 N202MHSouthern Utah University · Cedar City, UTBuilt 1993 · S/N 52057 N202TPHeartland Aviation LLC · Ada, OKBuilt 2007 · S/N 52364 N2036FBell Textron Inc · Fort Worth, TXBuilt 1995 · S/N 52123 N203EHDsl Aviation LLC · Perham, MNBuilt 1993 · S/N 52023 N205GRCentral States Helicopters Inc · Wood River, NEBuilt 1994 · S/N 52101 N2064SAgricultural Air Services LLC · Jupiter, FLBuilt 1992 · S/N 52002 N206FCAlpha Bravo Two LLC · Fort Lauderdale, FLBuilt 2010 · S/N 52420 N206LJJohnson Flying Service LLC · Exira, IABuilt 2009 · S/N 52394 N206SGClassic Medical Inc · Salt Lake City, UTBuilt 2000 · S/N 52240 N209CPSouthern Helicopters Inc · Sunshine, LABuilt 2006 · S/N 52339 N20TVHelicopters Inc · Linden, NJBuilt 1994 · S/N 52084 N216MHMeridian Helicopters LLC · Broussard, LABuilt 2004 · S/N 52296 N217MHMeridian Helicopters LLC · Broussard, LABuilt 1999 · S/N 52226 N225GHRayburn Asset Holdings LLC · Mansfield, TXBuilt 1995 · S/N 52143 N227MHDelta Southern Resource Leasing LLC · Baton Rouge, LABuilt 2009 · S/N 52391 N228PBCrop Flight LLC · Divernon, ILBuilt 1993 · S/N 52033 N230MHLivingston Parish Sheriff'S Office · Livingston, LABuilt 1995 · S/N 52146 N232MHLipsey Helicopter Rental Co LLC · Chattanooga, TNBuilt 1997 · S/N 52195

Back to AD 2001-20-03