Skip to content

Registered aircraft · 34

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('05901H7', '059010L', '0590036', '05902FL', '05903YS')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('05901H7', '059010L', '0590036', '05902FL', '05903YS')
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.

N105WDWarren Donald J · Casco, MES/N 16332 N142SECowan Herb · Round Rock, TXS/N 2200 N2487EMcelheny Steven G · Oak Lawn, ILBuilt 2004 · S/N 16440 N2527RWiles Randall W · Huntington, WVBuilt 2002 · S/N 16262 N2609AHaugland Arthur M · Tolna, NDBuilt 2004 · S/N 16392 N2629ELong William E · Old Town, FLBuilt 2004 · S/N 16265 N2656PSturdivant Steven R · West Monroe, LABuilt 2014 · S/N 16306 N3156FKinscherff Mark · Nebo, ILBuilt 2003 · S/N 16315 N3163YFitzhenry Thomas M · Richfield, MNBuilt 2007 · S/N 16322 N31731Annis Larry · Mattoon, ILBuilt 2002 · S/N 16264 N35153Kielar Richard W · Riverton, UTBuilt 2002 · S/N 16254 N4005HFettig Dale H · Jamestown, NDBuilt 2004 · S/N 16418 N435BEMiller Gilbert · Richmond, KYBuilt 2004 · S/N 16373 N468AFSpa Matthew J · Kampsville, ILS/N 16304 N4813EClark Dean A · Lidgerwood, NDBuilt 2002 · S/N 16998 N50344Darnell Gary · Church Hill, TNBuilt 2003 · S/N 16397 N50370Finchum Daniel · New Market, TNBuilt 2004 · S/N 16381 N5041TBecker Shawn W · Kampsville, ILBuilt 2003 · S/N 16320 N507PSBeaman Brice S · Alger, OHBuilt 2003 · S/N 16358 N51603Cambron Doug M · Utica, KYS/N 16242 N55026Kaufman Timothy L · Palm City, FLBuilt 2007 · S/N 16340 N5549VZirbel Dennis R · De Pere, WIBuilt 2007 · S/N 16833 N6044AChristopher K Lobdell · Kokomo, INBuilt 2006 · S/N 16429 N6044BShell James R · Bremen, INBuilt 2003 · S/N 16361 N610BMMcdaniel Robert L · Columbia, ILBuilt 2004 · S/N 16418 N6177FPritchett David B · Anderson, INBuilt 2002 · S/N 16253 N638EBCzerwinski Brian J · Oak Creek, WIBuilt 2004 · S/N 16403 N65797Funk Luke · Dallas Center, IABuilt 2002 · S/N 16256 N672MRLutes Martin E · Saint Joseph, MOBuilt 2004 · S/N A 11 MEL N765WPrentiss Barton P · Sequim, WABuilt 2004 · S/N 164900 N7680CParunak Gene P · Saline, MIBuilt 2005 · S/N 16462 N8611EBeckman Alan C · Lexington, KYBuilt 2004 · S/N 16441 N92162Head Larry N · Celina, TNBuilt 2004 · S/N 16413 N92928Kwarciany William L · Escanaba, MIBuilt 2003 · S/N 16330

Back to Buckeye BREEZE