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.

N421HMGottshall Curt · Monroe, WABuilt 1970 · S/N 421B0029 N421HRRons Air Service Inc · Two Buttes, COS/N 421B0945 N421HZDickert Investments - Flying Dicks LLC · Cave Creek, AZBuilt 1972 · S/N 421B0260 N421JMSchuck James M · Downey, CABuilt 1975 · S/N 421B0956 N421KSEnvironmental Manufacturing Solutions Ltd · Melbourne, FLBuilt 1973 · S/N 421B0507 N421MCBlue Bottom Inc · Los Angeles, CABuilt 1972 · S/N 421B0321 N421MYOzark Trails Youth Services Inc · West Plains, MOS/N 421B-0356 N421PDDavis Paul · Rockwall, TXBuilt 1975 · S/N 421B0960 N421PFNorthwest Georgia Aviation LLC · Rome, GAS/N 421B0400 N421PZGloria Bachelder Md Pc DBA · Erie, COBuilt 1974 · S/N 421B0806 N421RCSeremet Sasa · Beaver Dam, WIS/N 421B0604 N421RHWorld Tradex Inc · Missoula, MTS/N 421B0605 N421SEQuonset Aviation LLC · North Kingstown, RIBuilt 1973 · S/N 421B0393 N421TMEdelman Seth · Gig Harbor, WABuilt 1974 · S/N 421B0659 N421VCEr Aviation LLC · Brazil, INS/N 421B0428 N421VVTower Aviation Management LLC · Wilmington, DEBuilt 1975 · S/N 421B0959 N421WDKilo Aviation LLC · East Peoria, ILBuilt 1973 · S/N 421B0469 N421WXCeaco Inc · Las Vegas, NVS/N 421B0262 N421YPWateractive43 LLC · Auburn, CAS/N 421B0511 N4251TJett Shelby Kerman · Pewee Valley, KYS/N 421B0533 N42776Hap'S Air Inc · Ames, IABuilt 1973 · S/N 421B0394 N42BCRotary Components International Inc · Houston, TXBuilt 1975 · S/N 421B0922 N42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationBuilt 1972 · S/N 421B0342 N42YZPharaoh Aviation LLC · Velma, OKBuilt 1973 · S/N 421B0385 N440JBAg Tech Farm Services · Gamaliel, KYBuilt 1975 · S/N 421B0858 N4440KKate & Jennifer Airlines LLC · Tampa, FLBuilt 1974 · S/N 421B0567 N444ATCore Aviation LLC · Dayton, OHS/N 421B0897 N444SMPosada Law Pllc · Boca Raton, FLBuilt 1974 · S/N 421B0814 N444TAMiller Conner · Lake Havasu City, AZBuilt 1973 · S/N 421B0390 N44KFEbert Construction Co Inc · Wamego, KSBuilt 1974 · S/N 421B0598 N456HACeltic Air Inc · Lake City, FLBuilt 1974 · S/N 421B0614 N458VCWing And A Prayer LLC · Sarasota, FLBuilt 1974 · S/N 421B0915 N467DMMustang Sally Aviation LLC · Camden, SCBuilt 1973 · S/N 421B0377 N469LCGaletti Ralph R · Albuquerque, NMBuilt 1974 · S/N 421B0627 N477MGJuliet Delta Aviation LLC · Bozeman, MTBuilt 1973 · S/N 421B0477 N48BPRossman Richard J DBA · Glenview, ILBuilt 1975 · S/N 421B0957 N49ARMoore Thomas A · Kennewick, WAS/N 421B0563 N4ADValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 421B0467 N4MUBlusky Properties & Investments LLC · Cameron, MOBuilt 1970 · S/N 421B0054 N500TJAirbyars LLC · Spartanburg, SCBuilt 1974 · S/N 421B0585 N502ATAir Note LLC · Delray Beach, FLBuilt 1973 · S/N 421B0547 N505RWCor Group LLC · Arlington, WAS/N 421B0268 N50DLSand Castle Management LLC · Wichita, KSBuilt 1973 · S/N 421B0526 N518BBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 421B0518 N52JVSl Leasing Group LLC · Atlanta, GABuilt 1973 · S/N 421B0459 N530DMBorders Nowell · Edinburg, TXS/N 421B0839 N5370JJaaam Skyline Inc · Middletown, DEBuilt 1975 · S/N 421B0920 N5371JColeair LLC · Lewes, DEBuilt 1975 · S/N 421B0921 N5397JCp Aviation LLC · Washington, DCBuilt 1975 · S/N 421B0947 N5443JKg&C Investment LLC · Saint Charles, ILBuilt 1975 · S/N 421B0901

Back to Cessna 421B