Skip to content

Registered aircraft · 660

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

N2475NSimpson Barry R · Safford, AZBuilt 1947 · S/N 12728 N2475VMoorman Paul L · Greensburg, INBuilt 1948 · S/N 14637 N2476VBartek Brandon L · Goldthwaite, TXBuilt 1948 · S/N 14642 N2478NGaylord Richard N · Bradenton, FLBuilt 1947 · S/N 12731 N2481NC M & K Enterprises Inc · Brandon, MSS/N 12734 N2490NCessna N24909n LLC · Jacksonville, FLBuilt 1947 · S/N 12743 N2492NAlbert Lea Airport Inc · Albert Lea, MNBuilt 1947 · S/N 12745 N2516NBigby Greg A · Reno, NVBuilt 1947 · S/N 12773 N2518NLittle Birdy Aviation LLC · San Antonio, TXS/N 12776 N2533NPhillips James T · Hickory Corners, MIFirst renewal noticeBuilt 1947 · S/N 12789 N2539NNichols Raymond L · Saint Anne, ILBuilt 1947 · S/N 12795 N2554NStanek Michael K · Palm Bay, FLS/N 12810 N2557NLucarelli Nicholas V · Bonneau, SCBuilt 1947 · S/N 12813 N2566NAdams Eddie · Senath, MOBuilt 1947 · S/N 12822 N2586NNoblin Michael A · Readyville, TNBuilt 1947 · S/N 12846 N2589NOlson Andrew J · Vail, AZBuilt 1947 · S/N 12849 N2592NEdwards Christopher V · Seattle, WABuilt 1946 · S/N 12852 N2595NNampa Taildragger Flying Club Inc · Nampa, IDBuilt 1947 · S/N 12855 N2601NDisch Dennis F · Pewaukee, WIBuilt 1947 · S/N 12861 N2606NSchutt Michael J · Kimberling City, MOS/N 12866 N2613NMancusi Joseph F · Gold Hill, NCBuilt 1947 · S/N 12873 N2619NJohnston Andrew J · Erwinna, PABuilt 1947 · S/N 12879 N2642NCharles Trower Aviation Inc · Scobey, MTBuilt 1947 · S/N 12900 N2660NMoment Lisa A · Urbana, ILBuilt 1947 · S/N 12918 N2672NBartholomew Jim F · Storm Lake, IABuilt 1947 · S/N 12930 N2675NMurrell James F Sr · Douglas, AZS/N 12933 N2681NPayne Michael · Sequim, WABuilt 1947 · S/N 12939 N2683NBennett William Nicholas · Donalds, SCS/N 12941 N2684NAir & Sea Leasing Inc · Cahokia, ILBuilt 1947 · S/N 12942 N2702NKane Christopher M · Montevideo, MNS/N 12960 N2708NGoldstein Michael F · Medina, OHBuilt 1947 · S/N 12966 N2714NMiss May Aviation Inc · Brookfield, MABuilt 1947 · S/N 12972 N2723NTrahan John · Lebanon, ORBuilt 1947 · S/N 12981 N2735NEvans Earl J · Oglethorpe, GABuilt 1947 · S/N 12993 N2757NBenedict Michael T · Anchorage, AKBuilt 1947 · S/N 13015 N2765NAdverse Yaw LLC · Erie, COBuilt 1947 · S/N 13023 N2771NMeyer Corben D · Lafayette, INS/N 13029 N2773NMidwest Corporate Air Inc · Bellefonatine, OHBuilt 1947 · S/N 13031 N2780NSparkys Flying Service LLC · Warner, NHBuilt 1947 · S/N 13041 N2783NValbert Gilbert L · Martinsville, INBuilt 1947 · S/N 13044 N2792NSanfillipo Leah M · Tehachapi, CABuilt 1947 · S/N 13053 N2799NJon D Robb · Alma, MIS/N 13060 N2801NK & K Aircraft LLC · Culver, ORBuilt 1947 · S/N 13062 N2813NRussell Richard E · Holt, FLBuilt 1947 · S/N 13074 N2814NGrahn Victor A Jr · Bellevue, MIBuilt 1947 · S/N 13075 N2815NScialabba John E · Columbus, OHBuilt 1947 · S/N 13076 N2817NEagles Nest Projects Wisonsin · Burlington, WIS/N 13078 N2830NHanke Peter W · Chimacum, WABuilt 1947 · S/N 13091 N2834NPoland Marvin W · Tawas City, MIBuilt 1947 · S/N 13095 N2856NPoor Boys Flying Club Incorporated · Osborne, KSBuilt 1947 · S/N 13117

Back to Cessna 120