Skip to content

Registered aircraft · 50

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

N1GUHabbal Wissam · Rosamond, CABuilt 1957 · S/N 5610 N1YYFlying Low Racing LLC · Oklahoma City, OKBuilt 1956 · S/N 5602 N26CCook George W · Austin, TXBuilt 1958 · S/N 5661 N3000GSheets Bruce E · Brooklyn, NYBuilt 1959 · S/N 5692 N3001GReed Bryan K · Oakdale, NES/N 5693 N3004GSmith Todd Allen · Belleview, FLBuilt 1959 · S/N 5696 N3005GParker Joy M · Springfield, MOBuilt 1959 · S/N 5697 N3007GGregory Vernon L · Swansea, SCBuilt 1959 · S/N 5699 N3009GGregory Vernon L · Swansea, SCBuilt 1959 · S/N 5701 N3016GLucas Daniel J · Collinsville, TXBuilt 1959 · S/N 5708 N3021GHamboys Aviation LLC · Hermitage, PAS/N 5714 N323TBBoatright Kenneth R · Louisville, KYBuilt 1959 · S/N 5705 N6132CSnodgrass James T · Gallipolis, OHBuilt 1956 · S/N 5606 N6136CRegan Corey J · Tehachapi, CABuilt 1956 · S/N 5607 N6139CDaughters Turpen A · Sun City, AZBuilt 1957 · S/N 5608 N7500CBancroft Diane F · Hernando, FLBuilt 1957 · S/N 5612 N7504CSmith Douglas B · Channahon, ILBuilt 1957 · S/N 5614 N7508CPhilip Sims · Otis, COS/N 5618 N7513CThomas Ronald L · Green Cove Springs, FLBuilt 1957 · S/N 5623 N7515CPrater Jon Aaron · Palm Coast, FLBuilt 1957 · S/N 5626 N7516CLubben Justin K · Dayton, VAS/N 5627 N7519CCooke Riley O · Bridger, MTBuilt 1958 · S/N 5634 N7520CKimball Hyland F · Columbus, NMBuilt 1958 · S/N 5635 N7521CKorn Kenneth A · Tallahassee, FLBuilt 1958 · S/N 5636 N7526CTrottier Trevor · Hyde Park, VTBuilt 1958 · S/N 5641 N7531CGregory Vernon L · Swansea, SCBuilt 1958 · S/N 5646 N7535CBerkbiegler L Allen · Lonedell, MOBuilt 1958 · S/N 5650 N7536CCarroll Trent M · Corpus Christi, TXBuilt 1958 · S/N 5651 N7537CChmiel John E · Rhinelander, WIBuilt 1958 · S/N 5652 N7539CRandles Colt L E · Fayetteville, NCBuilt 1958 · S/N 5654 N7541CBryan Paul D · Prineville, ORBuilt 1958 · S/N 5656 N7542CSinclair Leonard A · Gypsum, COBuilt 1958 · S/N 5657 N7543CArnold Charles W · San Diego, CABuilt 1958 · S/N 5658 N7548CVandervoort Karen K · Waller, TXBuilt 1958 · S/N 5663 N7549CMarsden Heath H · Newport, NHBuilt 1958 · S/N 5664 N7550CRoman Steven T · Burgettstown, PAS/N 5667 N7551CStradley Roger I · Belgrade, MTS/N 5668 N7552CLancaster Clinton E Jr · Pikeville, NCS/N 5669 N7553CMccall Richard Alan · Lexington, NCBuilt 1958 · S/N 5670 N7556CHowe Robert T · Forked River, NJBuilt 1959 · S/N 5673 N7557CSims Michael R · Clancy, MTBuilt 1959 · S/N 5674 N7559CProplastic Designs Inc DBA · Charlotte, NCBuilt 1959 · S/N 5676 N7562CGraziano Thomas K · Benson, AZBuilt 1959 · S/N 5679 N7563CQuandt Richard L · South Sioux City, NES/N 5680 N7566CAnton Paul M · Salome, AZBuilt 1959 · S/N 5683 N7567CVorpe Thomas · Pearland, TXBuilt 1959 · S/N 5684 N7568CSmundin George · Munster, INBuilt 1959 · S/N 5685 N7569CBellamy John Mark · Savannah, NYBuilt 1959 · S/N 5686 N7571CEastland Walter J · Frankston, TXBuilt 1959 · S/N 5688 N7573CReynolds Terry · Phoenix, AZBuilt 1959 · S/N 5690

Back to Forney F-1