Skip to content

Registered aircraft · 225

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

N31KTSmith Kenneth L · Pomona, CABuilt 1970 · S/N 421B0011 N321HASkytook LLC · Wilmington, DEBuilt 1973 · S/N 421B0420 N333CJDrj Aviation LLC · Dover, DEBuilt 1972 · S/N 421B0313 N333KWD G R Air LLC · Braselton, GABuilt 1974 · S/N 421B0657 N3377QMendez Jr Leo · Corpus Christi, TXS/N 421B0261 N3540MDybel William P · Frankfort, ILS/N 421B0472 N355RTBeechwood Aviation LLC · Wilmington, DEBuilt 1974 · S/N 421B0633 N35FSSelistli LLC · San Mateo, CABuilt 1974 · S/N 421B0831 N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584 N37JKSsr LLC · Incline Village, NVS/N 421B0934 N37MBresciani Martin · Guaynabo, PRS/N 421B0805 N382MCShiver James B · Stanley, NMS/N 421B0452 N384AMHaggard Haley G · Springer, OKS/N 421B0304 N400BJAirrich LLC · Largo, FLBuilt 1974 · S/N 421B0819 N400CEMcmurray Bradley Thomas · Advance, NCBuilt 1975 · S/N 421B0930 N400TMPaxton Homes LLC · Killeen, TXS/N 421B0885 N40JCDbs Aviation LLC · Sulphur Springs, TXBuilt 1973 · S/N 421B0384 N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401 N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412 N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576 N41085421 Bravo LLC · Marine City, MIS/N 421B0440 N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422 N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589 N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458 N41124Wenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1973 · S/N 421B0465 N411TBLewis Nathan · North Plains, ORS/N 421B0481 N411ZJkdj LLC · Tyler, TXBuilt 1973 · S/N 421B0482 N415RABoas Mark S · Hollywood, MDBuilt 1975 · S/N 421B0874 N41PBCrestview Residential Properties LLC · Laurinburg, NCBuilt 1974 · S/N 421B-0845 N41SPN41sp LLC · New Port Richey, FLBuilt 1975 · S/N 421B0937 N421AHJ R Herring Enterprises Inc · Wellington, FLBuilt 1975 · S/N 421B0924 N421BNOne Golden Eagle LLC · Kalispell, MTS/N 421B0586 N421BPMed Jets USA Inc · Boca Raton, FLBuilt 1973 · S/N 421B0388 N421BXCrystal Air LLC · Brighton, MAS/N 421B0391 N421CKKarow Robert J · Rosharon, TXBuilt 1973 · S/N 421B0470 N421CLEmployment Services Inc DBA · Virginia Beach, VABuilt 1973 · S/N 421B0480 N421CRPaw Aviation LLC · La Porte, INBuilt 1971 · S/N 421B0224 N421CTArizona Air Salvage · Phoenix, AZBuilt 1973 · S/N 421B0510 N421DKRegistration Pending · Sonoma, CARegistration pendingBuilt 1974 · S/N 421B0825 N421ESmith Russell N · Pensacola, FLBuilt 1974 · S/N 421B0599 N421EZN421ez LLC · Rochelle, ILBuilt 1974 · S/N 421B0608 N421FAAll In Aviation LLC · Longview, TXBuilt 1973 · S/N 421B0431 N421FMAxis Aviation LLC · Cape Canaveral, FLBuilt 1974 · S/N 421B0841 N421GCBtc Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 421B0926 N421GEMels Priced Right Custom Carts · Lakeland, FLBuilt 1970 · S/N 421B0109 N421GGScientific Flight Corp · Shorewood, ILBuilt 1974 · S/N 421B0848 N421GHArx Aviation LLC · Apopka, FLBuilt 1973 · S/N 421B-0483 N421GRInvestors Management LLC · Fort Payne, ALBuilt 1993 · S/N 421B0597 N421GWGrinnell Allen L · Derry, NHBuilt 1974 · S/N 421B0873 N421HHNunez Salvador · Calexico, CAS/N 421B0661

Back to Cessna 421B