Skip to content

Registered aircraft · 127

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 ('0631410', '0630711')
  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 ('0631410', '0630711')
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.

N1000SButler County Warbirds Inc · Middletown, OHBuilt 1972 · S/N AA5-0107 N100YAShelton Joel T · Grass Valley, CAS/N AA5-0086 N155BYYount Brian C · Fullerton, CAS/N AA5-0184 N1613WArnold Stephen Paul · Falls Church, VABuilt 1972 · S/N AA5-0073 N1972GCapone Eugene L DBA · Frisco, TXBuilt 1972 · S/N AA5-0157 N1973THogs & Hoses LLC · Seguin, TXBuilt 1972 · S/N AA5-0233 N200BDEason Charles E · Locust Grove, GABuilt 1972 · S/N AA5-0159 N211JKNelson Christopher B · Fort Atkinson, WIBuilt 1972 · S/N AA5-0049 N2145FSmith Jeffrey D · Hamilton, GABuilt 1972 · S/N AA5-0017 N21GWBing Kenneth · Millersport, OHBuilt 1972 · S/N AA5-048 N33JJFincor Inc · Miami Beach, FLBuilt 1972 · S/N AA5-0061 N404RBMyrehn Bruce D · Carmel, INBuilt 1972 · S/N AA5-0101 N40FAWright Paul G Trustee · Scotts Valley, CABuilt 1972 · S/N AA5-0114 N50FABeck Frank · Arvada, COBuilt 1972 · S/N AA5-154 N528CCPositive Attitudes Of Zephyrhills LLC · Zephyrhills, FLBuilt 1972 · S/N AA5-0149 N5626LMw Aviators LLC · Olathe, KSBuilt 1972 · S/N AA5-0226 N5798LLymburner Lawrence E · Lehigh Acres, FLBuilt 1972 · S/N AA5-0207 N5802LHarrold Michael C · Hamilton, MTBuilt 1971 · S/N AA5-0002 N5804LAa Horizons LLC · League City, TXBuilt 1971 · S/N AA5-0004 N5806LSutphin Christoper F · Darlington, SCS/N AA5-0006 N5808LChristensen Donald R · Anchorage, AKBuilt 1971 · S/N AA5-0008 N5809LNealy William · Heath, TXS/N AA5-0216 N5812LLindly Lowell J · Nashville, ARBuilt 1971 · S/N AA5-0012 N5815LFidler Richard · San Francisco, CABuilt 1972 · S/N AA5-015 N5816LSparrowhawk Aviation LLC · Moraine, OHBuilt 1972 · S/N AA5-0016 N5819LLandauer Jacob · Gainesville, FLBuilt 1972 · S/N AA5-0219 N5825LMahurin Devin · Mountain Grove, MOBuilt 1972 · S/N AA5-0025 N5826LGibson Bobby S · Clearwater, FLBuilt 1972 · S/N AA5-0026 N5831LCooks Aviation LLC · Conover, NCBuilt 1972 · S/N AA5-0231 N5832LPlesea Lucian · Redlands, CABuilt 1972 · S/N AA5-0232 N5834LFount Valley Flying Club LLC · Kidron, OHS/N AA5-0034 N5837LDudock John M Jr · Birch Run, MIBuilt 1972 · S/N AA5-0037 N5838LCox Andrew C · Scappoose, ORBuilt 1972 · S/N AA5-0038 N5839LHoyer Chase R · Jarrell, TXBuilt 1972 · S/N AA5-0039 N5842LBerner Walter T III · Stamford, CTBuilt 1972 · S/N AA5-0042 N5843LMaschek Scott · Harker Heights, TXBuilt 1972 · S/N AA5-0043 N5844LHennell Elizabeth · Orrville, OHBuilt 1972 · S/N AA5-0044 N5845LKunkel Dennis J Co Trustee · Clearwater, MNBuilt 1972 · S/N AA5-0045 N5848LN5848l LLC · San Francisco, CABuilt 1972 · S/N AA5-0248 N584LLawver William A · Panama City, FLBuilt 1972 · S/N AA5-0084 N5850LXeus Inc · Nottingham, PABuilt 1972 · S/N AA5-0050 N5851LOretsky Philip H · South Haven, MIBuilt 1972 · S/N AA5-0051 N5852LOhser David G · Hudson, FLBuilt 1972 · S/N AA5-0052 N5853LKennedy Samuel E · Watsonville, CABuilt 1972 · S/N AA5-0053 N5854LVolpe Brandon M · Baton Rouge, LABuilt 1972 · S/N AA5-0254 N5855LSchauf Cindy R · Colwich, KSBuilt 1972 · S/N AA5-0055 N5856LOrland Flying Service Inc · Bunnell, FLBuilt 1972 · S/N AA5-0056 N5857LHill James III · Gainesville, FLBuilt 1972 · S/N AA5-0057 N5860LBeede Curtis M Trustee · Maineville, OHBuilt 1972 · S/N AA5-0060 N5862LAnderson Terry L · Lincoln, NES/N AA5-0062

Back to American AA-5