Skip to content

Registered aircraft · 277

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

N3835CPreferred Airparts LLC · Apple Creek, OHBuilt 1973 · S/N 310Q0671 N3TQAbove Blue Line LLC · Austin, TXBuilt 1973 · S/N 310Q0752 N3VJMiasnikowicz Victor · Lancaster, PABuilt 1973 · S/N 310Q0746 N400WMBryan Craig · Ellisville, MSBuilt 1972 · S/N 310Q0634 N40484Sunland Air Inc · Frederick, MDBuilt 1973 · S/N 310Q-0735 N4063QThin Air Inc · Hays, KSBuilt 1973 · S/N 310Q0724 N417EC417ec LLC · Sheridan, WYBuilt 1972 · S/N 310Q0539 N41LCBowen William A III · California, MDBuilt 1972 · S/N 310Q0502 N42SSBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 310Q0682 N431BRLockyer Roch Jr · Austin, TXBuilt 1970 · S/N 310Q0221 N433YHRegistration Pending · Stuart, FLRegistration pendingS/N 310Q0998 N4420MJohnson Capital LLC · Colleyville, TXBuilt 1973 · S/N 310Q0808 N444STPeterson Ocean Tours LLC · Pace, FLS/N 310Q0605 N4546QHarlow Jack M · Benbrook, TXBuilt 1973 · S/N 310Q0728 N466QBiziorek Thomas R · Harbor Springs, MIBuilt 1972 · S/N 310Q0534 N47BGVonweisenstein Thomas W · Brentwood, TNBuilt 1974 · S/N 310Q1061 N497JMBazzi Aviation LLC · Newark, DEBuilt 1972 · S/N 310Q0497 N4PJAnderson Richmond E Jr · Orlando, FLBuilt 1972 · S/N 310Q-0515 N533CEHoward David D · Winner, SDBuilt 1969 · S/N 310Q0034 N567Herr John Robert · Saint Petersburg, FLFirst renewal noticeBuilt 1972 · S/N 310Q0459 N575HBHot Damn Flying Service LLC · Palm Coast, FLBuilt 1973 · S/N 310Q0788 N588DMColeman Russell Ll · Saint Charles, ILBuilt 1973 · S/N 310Q0624 N589DMGeorgescu Radu A · Louisville, KYS/N 310Q1048 N594WBUintacor Inc · Mesa, AZS/N 310Q0077 N5951MMcdonnell Enterprises Inc · Wilmington, DEBuilt 1973 · S/N 310Q0737 N5LHIsland Creek Partners LLC · Alpine, CABuilt 1973 · S/N 310Q0939 N610AKBaja Electric Service Inc · Punta Gorda, FLBuilt 1974 · S/N 310Q-1072 N620JPPreiss Aviation Inc · Poplar Grove, ILBuilt 1972 · S/N 310Q0639 N6268QChuss Edward J · Metamora, MIS/N 310Q0526 N6277QFly Me LLC · Sparta, TNBuilt 1973 · S/N 310Q0747 N6283QOn Glidepath Properties LLC · Gilbert, AZBuilt 1972 · S/N 310Q0492 N63DETri-Air LLC · Cedartown, GABuilt 1972 · S/N 310Q0675 N647TWWeigle Gerald V Jr Trustee · Cincinnati, OHBuilt 1973 · S/N 310Q0815 N66CWSpannhake John H · Washington, CTBuilt 1973 · S/N 310Q0844 N67CMSmith Kenneth L · Pomona, CABuilt 1973 · S/N 310Q0977 N69570Pilot Farm LLC · Grant, NEBuilt 1973 · S/N 310Q0901 N69572Phillips Aviation LLC · Winnemucca, NVBuilt 1973 · S/N 310Q0790 N69573Air Plains Services Corp · Wellington, KSBuilt 1973 · S/N 310Q0791 N69575N69575 LLC · Ypsilanti, MIBuilt 1973 · S/N 310Q0793 N69584M D Air Ops LLC · High Springs, FLBuilt 1973 · S/N 310Q0801 N69604Sky West Aviation Inc Trustee · Albuquerque, NMS/N 310Q0812 N69622Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1973 · S/N 310Q0904 N69646Foxtrot Zulu Inc · Loganville, GAS/N 310Q0832 N69648Clow Streeter M · Mansfield, OHS/N 310Q0833 N69657Registration Pending · Poplar Grove, ILRegistration pendingBuilt 1973 · S/N 310Q0836 N69658Air Aller LLC · Blaine, MNBuilt 1973 · S/N 310Q0837 N69663Speas Stephen T · Winston Salem, NCBuilt 1973 · S/N 310Q0840 N69665Tony Flies Inc · Sparta, NCS/N 310Q0841 N69673Antonini Vittorio · New York, NYS/N 310Q0845 N69694Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 310Q0924

Back to Cessna 310Q