Skip to content

Registered aircraft · 1,065

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

N8506GNighthawk Air Systems Inc · Miami, FLS/N 15062606 N8507GCaldera Michael E · Williamsport, PABuilt 1965 · S/N 15062607 N8509GVictory Family Church Of Decatur Tx Inc · Decatur, TXBuilt 1965 · S/N 15062609 N8518GDouble Rr Holdings LLC · Dallas, TXBuilt 1965 · S/N 15062618 N8519GSullivan Aviation Maintenance LLC · Fayetteville, NCS/N 15062619 N8523GStephany Peter T · Umatilla, FLS/N 15062623 N8526GLong Sean · Germantown, TNBuilt 1966 · S/N 15062626 N8527GAcosta Alfredo · Yuma, AZBuilt 1965 · S/N 15062627 N8528GTulsa Technology Center School Dist No 18 · Tulsa, OKBuilt 1965 · S/N 15062628 N8534GBennett Julie L · Titusville, FLBuilt 1965 · S/N 15062634 N8535GSpeedbird Aviation One LLC · Glenn Heights, TXBuilt 1965 · S/N 15062635 N8536GMarcu David · Killen, ALS/N 15062636 N8537GNugent David R · Jensen Beach, FLBuilt 1965 · S/N 15062637 N8541GDeseh Sarah · San Diego, CABuilt 1965 · S/N 15062641 N8557GDoddi Vikram · Austin, TXBuilt 1965 · S/N 15062657 N8559GAeronautical Technical Service Inc · Collierville, TNS/N 15062659 N8561GFox Harvey · Lititz, PABuilt 1965 · S/N 15062661 N8565GFreedom Flight Service LLC · Glendale, AZBuilt 1965 · S/N 15062665 N8566GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062666 N8568GSkeen Harry K · Philippi, WVBuilt 1966 · S/N 15062668 N8570GGreenville Pilots Association Eaa Chapter 1382 · Greenville, ILS/N 15062670 N8573GFichtner Eric Lowell Russell · Concord, NCS/N 15062673 N8575GAero Services Lc · Woods Cross, UTS/N 15062675 N8576GSchaefer John · Liberty Hill, TXBuilt 1966 · S/N 15062676 N8577GLakey Robert E · Arlington, TXBuilt 1965 · S/N 15062677 N8580GRhoat William E · Paso Robles, CAFirst renewal noticeBuilt 1965 · S/N 15062680 N8585GCollins Terry R · Lewistown, ILBuilt 1965 · S/N 15062685 N8588GTulsa Technology Center School Dist No 18 · Tulsa, OKBuilt 1965 · S/N 15062688 N8589GRay Clinton R · Brighton, MIBuilt 1965 · S/N 15062689 N8590GAsher Charles S · Grosse Ile, MIBuilt 1965 · S/N 15062690 N8595GLazy 8 Flying Service LLC · Polson, MTBuilt 1965 · S/N 15062695 N8599GBoatright Michael L · Live Oak, FLBuilt 1966 · S/N 15062699 N8600GHunter Brian D · Scranton, IAFirst renewal noticeBuilt 1965 · S/N 15062700 N8601GRamakrishna Murali DBA · Burlington, MABuilt 1966 · S/N 15062701 N8601SDykstra Wayne A · Pipestone, MNS/N 15061901 N8605GPhelps John W · Spring Hill, FLBuilt 1965 · S/N 15062705 N8606SFlight Time Builders Inc · Memphis, TNBuilt 1965 · S/N 15061906 N8607GShooting Star Museum · Devine, TXBuilt 1965 · S/N 15062707 N8609GCourt Amy L · Staatsburg, NYBuilt 1965 · S/N 15062709 N8612GN8612g LLC · Orangeburg, SCBuilt 1965 · S/N 15062712 N8613SHanna Michael · Foristell, MOBuilt 1965 · S/N 15061913 N8614GShah Jawad A · Spring, TXBuilt 1965 · S/N 15062714 N8617SFrasch Randy D · Missoula, MTBuilt 1965 · S/N 15061917 N8618SBenson Dusty J · Melstone, MTBuilt 1965 · S/N 15061918 N8620SSorrell Zachariah G · Palmer, AKBuilt 1965 · S/N 15061920 N8621GKlopotek Jeffrey D · Waterman, ILFirst renewal noticeBuilt 1965 · S/N 15062721 N8623SBucks Flight Academy LLC · Cashion, OKBuilt 1965 · S/N 15061923 N8624SToth Frank L · Schenevus, NYS/N 15061924 N8625GDelong Erika Dee · Forest Lake, MNBuilt 1965 · S/N 15062725 N8625SMendoza Erik · Pleasanton, TXS/N 15061925

Back to Cessna 150F