Skip to content

Registered aircraft · 153

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 ('0630610')
  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 ('0630610')
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.

N1012GForwalt Lucas A · Chesapeake, VABuilt 1969 · S/N AA1-0122 N1970YCrosby A B Jr · Devine, TXBuilt 1970 · S/N AA10240 N21DYElliott Brandon D · Barstow, CAS/N AA1-0431 N221YMinolli Gregg A · Chelan, WABuilt 1968 · S/N AA1-0005 N223YDavis Tommy J · Ridgeville, SCS/N AA1-0011 N23RFJohnson Kevin R · Mansfield, TXBuilt 1969 · S/N AA1-0239 N2729XMoeplanes Co · Boynton Beach, FLBuilt 1970 · S/N AA1-0320 N274AARegistered aircraftS/N AA1-0230 N309AAEvans Luis · Locust Grove, GABuilt 1968 · S/N AA1-0002 N3LCStimson Andrew J · Battle Ground, WABuilt 1970 · S/N AA1-0401 N41HBWalsh Bowen S · North Augusta, SCBuilt 1969 · S/N AA1-0277 N525RTLester Wm Curtiss · Martinsville, VABuilt 1969 · S/N AA1-0207 N5601LManheimer Robert M · Marysville, WABuilt 1968 · S/N AA1-0003 N5606LJones Andrew S · Greensboro, GABuilt 1968 · S/N AA1-0008 N5612LHolden Jason K · Conroe, TXBuilt 1968 · S/N AA1-0014 N5614LFiler Jacob Adam · Clarksville, TNBuilt 1968 · S/N AA1-0016 N5615LAnthonson Ronald G · Cortland, NYBuilt 1968 · S/N AA1-0017 N5619LEncarnacion Ramon A · Miramar, FLS/N AA1-0021 N5620LRichardson Carl · Jonesboro, GABuilt 1968 · S/N AA1-0022 N5627LFrattarelli Marco · Carrollton, TXBuilt 1968 · S/N AA1-0027 N5631LKing Michael Wayne · Centreville, MDS/N AA1-0031 N5632LLas Vegas Aerial Services LLC · Las Vegas, NVS/N AA1-0032 N5634LOlson Mitch A · Silver Springs, NVBuilt 1968 · S/N AA1-0034 N5635LCentury Air Inc · Fairfield, NJBuilt 1968 · S/N AA1-0035 N5636LCrosby Thomas G · Saint Charles, MOS/N AA1-0036 N5643LChaney Timothy W · Peoria, AZBuilt 1968 · S/N AA1-0043 N5644LMartinez Pedro M · BreeNon-citizen corporation, flight hours not reportedBuilt 1968 · S/N AA1-0044 N5645LT2tc LLC · Enka, NCBuilt 1968 · S/N AA1-0045 N5646LHutcheson Bruce D · Anthem, AZBuilt 1968 · S/N AA1-0046 N5653LUlpiano Amy · Carolina, PRBuilt 1969 · S/N AA1-0053 N5657LSkyray LLC · Sugar Land, TXBuilt 1969 · S/N AA1-0057 N5658LBores Scott J · Huron, OHS/N AA1-0058 N5663LChino Aviation Inc · Chino, CAS/N AA1-0063 N5669LGallien Justin A · Livermore, CABuilt 1969 · S/N AA1-0069 N5670LCranford Julian Edward Jr · Lexington, NCBuilt 1969 · S/N AA1-0070 N5671LJudge Russell M · Newton, NJBuilt 1969 · S/N AA1-0071 N5677LDuncan Lincoln · Dix, ILBuilt 1969 · S/N AA1-0077 N5680LStackpole Thomas M · Temecula, CABuilt 1969 · S/N AA1-0080 N5682LLahlum Steven R · Warroad, MNBuilt 1969 · S/N AA1-0082 N5685LFritz Frank M · Milwaukee, WIBuilt 1969 · S/N AA1-0085 N5686LBresson Kyle M · Roxbury, CTBuilt 1969 · S/N AA1-0086 N5687LDedominici Kenneth · Vero Beach, FLS/N AA1-0087 N5688LDolan John C · Sequim, WAS/N AA1-0088 N5689LCalovini Christopher T · Gahanna, OHS/N AA1-0089 N5705LKing William C · Huntington Beach, CABuilt 1969 · S/N AA1-0105 N5717LChristian George D · Kingwood, TXBuilt 1969 · S/N AA1-0117 N5718LMullins John D · Harriman, TNS/N AA1-0118 N5719LGodoy Air LLC · Venice, FLS/N AA1-0119 N5720LKh Aircraft LLC · Denton, MTBuilt 1969 · S/N AA1-0120 N5721LBerggren Ryan J · Newton, NJBuilt 1969 · S/N AA1-0121

Back to American AA-1