Skip to content

Registered aircraft · 659

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

N51412Record John W · Apison, TNS/N 15069992 N51415Van Voorhis Adam P · Groton, CTBuilt 1968 · S/N 15069995 N51416Murphy Nicholas Raymond · Kenai, AKBuilt 1968 · S/N 15069996 N5480VFisher Nathan E · Northwood, NDS/N 15070655 N5502GKeeven Diana F · New Smyrna Beach, FLBuilt 1969 · S/N 15071002 N5505GOsterhaus Nolan · Blair, NEBuilt 1969 · S/N 15071005 N5506GSanchez Carlos D · Ashburn, VABuilt 1969 · S/N 15071006 N5507GBates Nicholas · Lawton, OKBuilt 1969 · S/N 15071007 N5508GBarberio Frank · Keswick, VABuilt 1969 · S/N 15071008 N5509GBottorff James R · Ada, OHBuilt 1969 · S/N 15071009 N5516GRegistration Pending · Cedar Hill, TXRegistration pendingBuilt 1969 · S/N 15071016 N5517GCarr Steven F · Wasilla, AKBuilt 1969 · S/N 15071017 N5520GRm Aero LLC · Santa Ynez, CABuilt 1969 · S/N 15071020 N5522GCoffroth James R · Jamestown, TNBuilt 1969 · S/N 15071022 N5523GSamadzai Ahmad W · Mount Vernon, ILBuilt 1969 · S/N 15071023 N5527GFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 15071027 N5528GRick Aviation Inc · Newport News, VABuilt 1969 · S/N 15071028 N5529GSmoot Jeremy D · Fort Wayne, INS/N 15071029 N5533GJaeger Robert G · Lake City, FLBuilt 1969 · S/N 15071033 N5545GTinkham Dennis T · Leavenworth, KSBuilt 1969 · S/N 15071045 N5549GFrantz Donna Pratt · Ocala, FLBuilt 1969 · S/N 15071049 N5557GSegura Richard J III · Henderson, TXS/N 15071057 N555NJCronin John · Stroudsburg, PABuilt 1968 · S/N 15069885 N5562GDurtschi Krista M · Hernando, MSBuilt 1969 · S/N 15071062 N5568GRygwall Brian · Blaine, MNS/N 15071068 N5570GGibbs Robert I · Ravenswood, WVBuilt 1969 · S/N 15071070 N5572GBug Smashers LLC · Winfield, KSBuilt 1969 · S/N 15071072 N5574GCastro Mauro E · Kingsville, TXBuilt 1969 · S/N 15071074 N5576GPruner Michael G · Klamath Falls, ORBuilt 1969 · S/N 15071076 N5578GGilbreath John W · Colt, ARBuilt 1969 · S/N 15071078 N5579GDavila Rudolfo · Runge, TXS/N 15071079 N5581GC&C Aero LLC · Billings, MTBuilt 1969 · S/N 15071081 N5582GPilot Am LLC · East Elmhurst, NYBuilt 1969 · S/N 15071082 N5588GSale Reported · Washington, UTSale reportedS/N 15071088 N5590GDelci Dino J · Tempe, AZBuilt 1969 · S/N 15071090 N5592GFleming Randy · Concord, NCS/N 15071092 N5593GDebartolo Samuel · Swampscott, MABuilt 1969 · S/N 15071093 N5594GDavis Joseph S · Andalusia, ALBuilt 1969 · S/N 15071094 N5595GZortman Micky P · Mexico, MOS/N 15071095 N5597GRegistration Pending · Washington, UTRegistration pendingBuilt 1969 · S/N 15071097 N5600GChimera Air Inc · Maumee, OHBuilt 1969 · S/N 15071100 N5605GMartinez Ivan A · Oro Valley, AZS/N 15071105 N5606GPinho Michel A · Santa Barbara, CABuilt 1969 · S/N 15071106 N5610GInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15071110 N5612GNelson Daniel J · Ladd, ILBuilt 1969 · S/N 15071112 N5626GGreer Management LLC · Salem, ORBuilt 1969 · S/N 15071126 N5628GJewell Jonathan T · Paducah, KYBuilt 1969 · S/N 15071128 N564QLSimcic Kathryn C · Grain Valley, MOBuilt 1969 · S/N 15070570 N569APotopowitz William III · Niantic, CTS/N 15070351 N5BWThompson Aubrey C · Wilmington, NCBuilt 1968 · S/N 15069426

Back to Cessna 150J