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.

N6748FStone Charles N · Chetopa, KSBuilt 1966 · S/N 15063348 N6749FWright Steven · Shelbyville, TNBuilt 1966 · S/N 15063349 N6752FRdd Enterprises LLC · Redmond, ORBuilt 1966 · S/N 15063352 N6754FCurrie Jeffrey L · Carlsbad, NMBuilt 1966 · S/N 15063354 N6756FFox Flying Club Inc · Lincoln, NERevoked, canceledBuilt 1966 · S/N 15063356 N6757FConsuelas Gold Tooth Emporium LLC · Sheridan, WYBuilt 1966 · S/N 15063357 N6759FAnderstedt Richard A · Clearwater, MNBuilt 1966 · S/N 15063359 N6760FClancy Mackenzie W · Grand Rapids, MIS/N 15063360 N6763FLogsdon Dale L Trustee · Alva, OKS/N 15063363 N6764FBruno Alfred T · Santa Rosa, CABuilt 1966 · S/N 15063364 N6766FAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1966 · S/N 15063366 N6769FGarvey Aviation Services · Erie, PABuilt 1966 · S/N 15063369 N6770FFaith Tabernacle Ministries Inc · Junction City, KSBuilt 1966 · S/N 15063370 N6772FIrlbeck Cyler M · Eden Prairie, MNBuilt 1966 · S/N 15063372 N6779FBeulah Ranch LLC · Cheyenne, WYBuilt 1966 · S/N 15063379 N6786FBeitz Norman Roy · Quitman, TXS/N 15063386 N6792FPatton Aviation LLC · Billings, MTBuilt 1966 · S/N 15063392 N6793FOgden John T · Meridian, IDBuilt 1966 · S/N 15063393 N6797FGriswold M Dallas · Cordele, GABuilt 1966 · S/N 15063397 N6802FMccall Freddie W Jr · Brewton, ALBuilt 1966 · S/N 15063402 N6803FBenson George R · Woodlake, CABuilt 1966 · S/N 15063403 N6805FGoodner Brian C · Brookston, INBuilt 1966 · S/N 15063405 N6806FWeakland Christopher · Halifax, VABuilt 1966 · S/N 15063406 N6809FCarlson Christian A L · Orange City, FLBuilt 1966 · S/N 15063409 N6810FAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 15063410 N6813FBuffalo Aviation LLC · Royal, NES/N 15063413 N6815FRemus Joseph D · Plano, TXFirst renewal noticeBuilt 1966 · S/N 15063415 N6818FBell Douglas W · Mattoon, ILBuilt 1966 · S/N 15063418 N6825FKieffer Jason M · Omaha, NEBuilt 1966 · S/N 15063425 N6826FJeppesen Thomas L · Stanton, MIBuilt 1966 · S/N 15063426 N6834FLecompte Kevin J · Lancaster, MABuilt 1966 · S/N 15063434 N6836FFoley Anthony · Savannah, GABuilt 1966 · S/N 15063436 N6837FSkyberjet LLC · Allen, TXBuilt 1966 · S/N 15063437 N6840FBushre David · Janesville, WIBuilt 1966 · S/N 15063440 N6842FRodriguez Leyla M · Bellflower, CABuilt 1966 · S/N 15063442 N6843FMoyers John Jason · Midlothian, VAFirst renewal noticeBuilt 1966 · S/N 15063443 N6845FHoward Donald E II · Ponca City, OKBuilt 1966 · S/N 15063445 N6847FFranko Gregory · Grindstone, PABuilt 1966 · S/N 15063447 N6848FWhitehead Mathew S · Leesville, LABuilt 1966 · S/N 15063448 N6849FDeangelis Jarrod A · Henderson, NVS/N 15063449 N6851FCarr Thomas W · Grand Blanc, MIBuilt 1966 · S/N 15063451 N6862FGradel Thomas A Jr · Irmo, SCBuilt 1966 · S/N 15063462 N6865FGeissler Robert William Jr · Baltimore, MDBuilt 1966 · S/N 15063465 N6866FLand Ross A · Cedar Rapids, IAS/N 15063466 N6868FVan Bielert Wouter · Haxtun, COS/N 15063468 N6872FSkybound Aircraft LLC · Blue Point, NYBuilt 1966 · S/N 15063472 N6876FPalmer Dana G · Gatesville, TXBuilt 1966 · S/N 15063476 N6882FHernandez Kevin F · Redmond, ORBuilt 1966 · S/N 15063482 N6891FN6891f LLC · Woodruff, SCBuilt 1966 · S/N 15063491 N6892FDent Kelly J · Locust Grove, GABuilt 1966 · S/N 15063492

Back to Cessna 150F