Skip to content

Registered aircraft · 234

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

N5451VParker James C · Cuthbert, GABuilt 1975 · S/N 21060952 N545WKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N 21060656 N550RESimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 21060968 N551JBValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 21061129 N59060Agriflite Services Inc · Wakarusa, INBuilt 1973 · S/N 21060059 N59073Hartenstine Michael Carl · Lancaster, CABuilt 1973 · S/N 21060069 N59105Allen Willis M Jr · El Cajon, CABuilt 1973 · S/N 21060093 N59141Peters Mark E · Newport News, VABuilt 1973 · S/N 21060118 N59210Safe Pilots Group LLC · Nyack, NYBuilt 1973 · S/N 21060161 N59240Banegas Jose Carlos Zankiz · Flint, TXBuilt 1974 · S/N 21060174 N59292Cloud Busters LLC · Goodrich, MIBuilt 1974 · S/N 21060196 N59299Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 21060199 N5DJMyers Bradley J · Madisonville, KYBuilt 1974 · S/N 21060399 N60617Williams Robert M · Red Hook, NYBuilt 1974 · S/N 21060595 N606TLK C Enterprises Of Basile · Basile, LAS/N 21060545 N61RBKiazen Black Mountain Holdings LLC · Black Mountain, NCBuilt 1974 · S/N 21060268 N661KBBaldeo Kessho I · Bay Shore, NYBuilt 1974 · S/N 21060292 N668DB686 Aviation LLC · Lakewood, COBuilt 1975 · S/N 21061003 N669EBBauman Ed · Casstown, OHBuilt 1975 · S/N 21061065 N711PJRender Chad · Pine Bluff, ARS/N 21061128 N711TMPeters James L Trustee · Brighton, MIBuilt 1976 · S/N 21061301 N7154DChick Theodore D · Beulah, NDBuilt 1972 · S/N 21059520 N720GEHoucke Pascal · Newtown, PABuilt 1975 · S/N 21060671 N732AVRomberg Wayne Dennis · Forked River, NJBuilt 1976 · S/N 21061371 N732AXAnimal Hospital Of Fayetteville Pa · Fayetteville, NCS/N 21061373 N732BHSeven Eagles Aviation Lc · Gainesville, FLBuilt 1976 · S/N 21061383 N732BYMartin James Dwight · Lancaster, PABuilt 1976 · S/N 21061398 N732CHRegistration Pending · Athens, TNRegistration pendingBuilt 1976 · S/N 21061406 N732DLN732dl LLC · Driftwood, TXBuilt 1976 · S/N 21061433 N732DZBbak Mik LLC · Ontario, ORBuilt 1976 · S/N 21061446 N732EEK6 Flying LLC · Murtaugh, IDS/N 21061450 N732ELAndiamo Aviation LLC · Georgetown, TXBuilt 1976 · S/N 21061456 N732EPPorebski L P Jr · Odessa, FLBuilt 1976 · S/N 21061459 N732EWFiller Leslie Trustee · Emerald Hills, CABuilt 1976 · S/N 21061466 N732EXBorszich Claude C Jr · Phoenix, AZBuilt 1976 · S/N 21061467 N732EZButler Aviation Llp · Smyrna, TNBuilt 1976 · S/N 21061469 N732FCRuhsam Harry M · Saint Augustine, FLBuilt 1976 · S/N 21061472 N732FJIrf LLC · Boonton Township, NJBuilt 1976 · S/N 21061478 N732FPLancair Of Texas DBA · Snyder, TXBuilt 1976 · S/N T21061482 N732FXJanitell Brandan M · Helena, MTBuilt 1976 · S/N 21061489 N732GGMurphy Niccolai A · Poway, CABuilt 1976 · S/N 21061497 N732GHPeters Brian E · Las Vegas, NVBuilt 1976 · S/N 21061498 N732GPGulf Pop Aviation · Saint Augustine, FLS/N 21061504 N732JTKittatinny Leasing Co Inc · Friendsville, TNBuilt 1976 · S/N 21061555 N732JZChalk 2 Inc · Apple Valley, CABuilt 1976 · S/N 21061561 N732KLWestern Radio Services Co · Prineville, ORBuilt 1976 · S/N 21061572 N744RCastaneda Jose · Yakima, WABuilt 1974 · S/N 21060521 N75EELgc Consulting Inc · Salisbury, NCBuilt 1975 · S/N 21060837 N7777SHood Company LLC · Nashville, TNBuilt 1972 · S/N 21059611 N777FWLewis Kent · Lake Oswego, ORBuilt 1974 · S/N 21060167

Back to Cessna 210L