Skip to content

Registered aircraft · 1,605

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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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.

N72558Crunp Wyatt J · Wasilla, AKBuilt 1946 · S/N 9728 N72562Planes & Parts Inc · Weston, FLBuilt 1946 · S/N 9732 N72563Prox Dennis W · Port Orange, FLBuilt 1946 · S/N 9733 N72565Latrobe Tail Draggers Inc · Greensburg, PABuilt 1946 · S/N 9735 N72569Bogart Sean A · Anchorage, AKS/N 9739 N72570Mori Glenn E · West Ossipee, NHBuilt 1946 · S/N 9740 N72585Bean David J · Miami, TXBuilt 1946 · S/N 9755 N72591Holben Thomas L · Centennial, COBuilt 1946 · S/N 9763 N725XFrank De Niro · Sebastopol, CABuilt 1946 · S/N 9723 N72605Davis Glenn A · Fair Oaks, CABuilt 1946 · S/N 9777 N72607Meyer Bros Ag LLC · Algona, IABuilt 1946 · S/N 9779 N72609Weeks Gary · Cecil, OHS/N 9785 N72619Van Horn Ross A · Mt Pleasant Mills, PABuilt 1946 · S/N 9795 N72620Rinker Gary L · Clayton, NMBuilt 1946 · S/N 9796 N72625Tobol Thane R · Ronan, MTBuilt 1946 · S/N 9801 N72627Schendel Richard E · Wilton, CABuilt 1946 · S/N 9803 N72633May Bernard A · Medina, OHBuilt 1946 · S/N 9809 N72637Rupp Ronald W · Homewood, CABuilt 1946 · S/N 9813 N72648Brommer Roger A · Lino Lakes, MNBuilt 1946 · S/N 9824 N72651Mx7 LLC · Hudson, OHBuilt 1946 · S/N 9827 N72652Veverka Merle G · Frederick, COBuilt 1946 · S/N 9828 N72657Howard Austin · Bloomfield, CTBuilt 1946 · S/N 9833 N72659Crotts Jon · Garden City, KSBuilt 1946 · S/N 9835 N72660Shaw Craig M · Pleasant Dale, NEBuilt 1946 · S/N 9836 N72665Banner Homes LLC · Salem, ORS/N 9841 N72672Grones John G · Port Orange, FLBuilt 1946 · S/N 9848 N72677Shill Otto S Trustee · Mesa, AZFirst renewal noticeBuilt 1946 · S/N 9853 N72680Zeegers Jozef N · Bellingham, WABuilt 1946 · S/N 9856 N72681Riggs Benjamin D · Reynoldsburg, OHBuilt 1946 · S/N 9857 N72685Warner Aric D · Rosamond, CAS/N 9861 N72687Registration Pending · Peru, MERegistration pendingBuilt 1946 · S/N 9863 N72691Davis Herbert W · Danville, ARS/N 9867 N72693Obritsch Monte R · Malcolm, NEBuilt 1946 · S/N 9869 N72699Cope Samuel A · Lamesa, TXBuilt 1946 · S/N 9875 N72705Adasiewicz William F J · Redwood City, CABuilt 1946 · S/N 9884 N72712Cook Robert M · Gainesville, GABuilt 1946 · S/N 9891 N72717Hoppers Danny C · Osceola, MOBuilt 1946 · S/N 9896 N72720C140 LLC · Lewes, DEBuilt 1946 · S/N 9899 N72721Smalley Roger A · Medford, ORBuilt 1946 · S/N 9900 N72726Friedman Jared D · Green Cove Springs, FLBuilt 1946 · S/N 9905 N72728Lake Alexis S · Lititz, PAS/N 9907 N72732Houston Jerry M · Hickory, NCBuilt 1946 · S/N 9911 N72733Lee John Y · Covina, CABuilt 1946 · S/N 9912 N72737Hogan Robert P · North Pole, AKBuilt 1946 · S/N 9916 N72740Lyons Andrew James · Mansfield, MABuilt 1946 · S/N 9919 N72741Gibson Roderick J · Blairsville, GABuilt 1946 · S/N 9920 N72742Jackovich Vincent B · Eldridge, IABuilt 1946 · S/N 9921 N72744Hiebert Nathan D · Newton, KSBuilt 1946 · S/N 9923 N72750Dekan Jason S · Eau Claire, WIS/N 9933 N72753Kahle Timothy R · Chattanooga, OKBuilt 1946 · S/N 9936

Back to Cessna 140