Skip to content

Registered aircraft · 534

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

N770DSSpirit Of America Foundation Inc · Chattanooga, TNBuilt 1998 · S/N 5500862 N771DEDhb Aviation LLC · Smithfield, NCBuilt 2005 · S/N 560-5591 N774SBAirmed International LLC · Birmingham, ALBuilt 2005 · S/N 560-0684 N778TBTrcc Inc · Visalia, CABuilt 2004 · S/N 550-1083 N77DZZkd Air LLC · Houston, TXBuilt 2001 · S/N 560-5168 N77JDJd Capital LLC · Fort Smith, ARBuilt 2001 · S/N 560-5190 N781SLBb & Ryder LLC · Conway, ARBuilt 2001 · S/N 560-5162 N785CC7 Highway Investors LLC · Leawood, KSBuilt 2002 · S/N 560-5275 N788TMT Air LLC · Birmingham, ALS/N 560-5505 N78XLGarmin International Inc · Olathe, KSBuilt 2005 · S/N 560-5578 N796MACypress Aircraft Sales LLC · Clermont, FLBuilt 2000 · S/N 550-0941 N798TAgeless Mens Health Holdings Inc · Scottsdale, AZBuilt 2003 · S/N 560-5307 N7HJHessjet LLC · Mc Donald, TNBuilt 2001 · S/N 550-0983 N800AMReading And Northern Aviation Inc · Port Clinton, PABuilt 2001 · S/N 560-5195 N800WTBode Aviation Inc · Albuquerque, NMBuilt 1998 · S/N 5500859 N801CBBaugh Aviation Services LLC · Orem, UTBuilt 2001 · S/N 560-0584 N801JSCitation 1 Juliet Sierra LLC · Uvalde, TXBuilt 2000 · S/N 560-5075 N802CAThree Thirty Three LLC · Collierville, TNBuilt 2002 · S/N 550-1034 N802TDAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 560-5153 N806JS83 Aviation LLC · Fort Lauderdale, FLBuilt 2000 · S/N 560-5083 N807BWTejama LLC · Amarillo, TXBuilt 2003 · S/N 560-0640 N807JCGwu LLC · Saint James, MOBuilt 2002 · S/N 560-0602 N807JSDx Air Fleet LLC · Daytona Beach, FLBuilt 2003 · S/N 560-5354 N808MNMilliken & Company · Greer, SCBuilt 2005 · S/N 560-5587 N809JSFe 5094 LLC · Kinston, NCS/N 560-5094 N80FDAma Freight LLC · Saint Clair Shores, MIBuilt 2002 · S/N 560-5225 N80XAirxl LLC · Carmel, INBuilt 1999 · S/N 560-5054 N810JBUnified Air Solutions LLC · Oldsmar, FLBuilt 2000 · S/N 560-5113 N814BRWinston Electric Inc · Lubbock, TXBuilt 1998 · S/N 5605003 N817BSAerodan Aviation LLC · Alpharetta, GABuilt 2000 · S/N 560-5106 N817EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 560-5058 N817EGEng Capital LLC · Houston, TXBuilt 2001 · S/N 5605215 N817LFPollard Aircraft Sales Inc · Fort Worth, TXBuilt 2001 · S/N 560-5150 N818BLBrenmar Corp · Lawrenceville, GABuilt 2003 · S/N 560-5328 N818SHSilverhawk Aviation Inc · Lincoln, NEBuilt 2001 · S/N 560-0581 N819SCHb4 LLC · Las Vegas, NVBuilt 1997 · S/N 550-0818 N819SHSilverhawk Aviation Inc · Lincoln, NEBuilt 2002 · S/N 560-0604 N823CBThunderbird Equipment LLC · Hillsboro Beach, FLBuilt 2006 · S/N 560-0697 N823JSAero Harbor Nc Ll · Charlotte, NCBuilt 2002 · S/N 560-5265 N824JSFe 5536 LLC · Kinston, NCBuilt 2005 · S/N 5605536 N830JSRoss Advisors LLC · Naples, FLBuilt 2002 · S/N 560-5274 N833JSFe 5107 LLC · Kinston, NCBuilt 2000 · S/N 5605107 N836JSFe 5186 LLC · Kinston, NCBuilt 2001 · S/N 560-5186 N837JSFe 5164 LLC · Kinston, NCBuilt 2001 · S/N 560-5164 N838JSFe Encore Plus III LLC · Kinston, NCBuilt 2002 · S/N 560-5237 N839JSRenflight LLC · Raleigh, NCBuilt 2004 · S/N 560-5356 N83SPKelbel Aviation LLC · Longview, TXBuilt 2001 · S/N 560-5202 N840JSFe 5282 LLC · Kinston, NCBuilt 2002 · S/N 560-5282 N841DWSouth Coast Aviation Inc · Portland, ORBuilt 2001 · S/N 560-5177 N841JSFe Xl 5253 LLC · Kinston, NCBuilt 2002 · S/N 560-5253

Back to AD 2003-03-21