Skip to content

Registered aircraft · 303

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

N3970UGreenland Mike P · Three Springs, PABuilt 1965 · S/N 15061370 N3973UInternational Air Services Inc Trustee · Carson City, NVS/N 15061373 N3974UBryant Carl J · Roseburg, ORBuilt 1965 · S/N 15061374 N3977USale Reported · Pineville, KYSale reportedBuilt 1965 · S/N 15061377 N3982USale Reported · Clearfield, UTSale reportedBuilt 1965 · S/N 15061382 N3984USchram Claire · Roselle, ILRegistration revokedBuilt 1965 · S/N 15061384 N3987UPrice Nathan J · Crawfordsville, INBuilt 1965 · S/N 15061387 N3988UJens Plane LLC · Marshall, VABuilt 1965 · S/N 15061388 N3991UWhite Earl L · Ridgeland, SCS/N 15061391 N3993URausch Nickalous R · Gettysburg, SDBuilt 1965 · S/N 15061393 N3996UGiguere David P · Kingwood, TXBuilt 1965 · S/N 15061396 N3998UAlbrecht Koby J · Lawrence, MABuilt 1965 · S/N 15061398 N4003UGambassi Saverio · Bealeton, VAS/N 15061403 N4005USteinberg Alan R · Iron Mountain, MIBuilt 1965 · S/N 15061405 N4010UPorter Christopher · Pinnacle, NCBuilt 1965 · S/N 15061410 N4011UGreene Pete M · Pembroke Pines, FLBuilt 1965 · S/N 15061411 N4012UMorris Donna L · Yelm, WABuilt 1965 · S/N 15061412 N4013ULetourneau University · Longview, TXBuilt 1965 · S/N 15061413 N4016UThompson Don E · Long Beach, CABuilt 1965 · S/N 15061416 N4019UWeeks Lindell M · Kingston, NHBuilt 1965 · S/N 15061419 N4025URichardson Richard A · Fort Worth, TXBuilt 1965 · S/N 15061425 N4027UTsukii Toshikazu · Tucson, AZBuilt 1965 · S/N 15061427 N4028UCesperalle Aviation LLC · Grassy Butte, NDS/N 15061428 N4029UPathfinder Aero Services LLC · Sheridan, WYS/N 15061429 N4032ULiberty University Inc · Lynchburg, VABuilt 1965 · S/N 15061432 N4037UDelgado Brandon · Moreno Valley, CABuilt 1965 · S/N 15061437 N4039UHendrickson Flying Service Inc · Rochelle, ILBuilt 1965 · S/N 15061439 N4041UCumberland Soaring Group Inc · Wiley Ford, WVBuilt 1965 · S/N 15061441 N4043UHawthorne Christopher J · Lafayette, LABuilt 1965 · S/N 15061443 N4045UKnutson Tristian A · Spokane, WABuilt 1965 · S/N 15061445 N4046UFox James E · Queen Creek, AZS/N 15061446 N4047UDurfey Kyle A · Tucson, AZBuilt 1965 · S/N 15061447 N4048UOshtemo Flyers LLC · Kalamazoo, MIBuilt 1965 · S/N 15061448 N4049UCatero Inc · Chickasha, OKBuilt 1965 · S/N 15061449 N4053USegura Jose · Chicago, ILBuilt 1965 · S/N 15061453 N4055UHanson Parry B · Eagle Creek, ORS/N 15061455 N4056UFranklin Timothy · Brentwood, TNBuilt 1965 · S/N 15061456 N4061UShreve Gary L · Midlothian, TXBuilt 1965 · S/N 15061461 N4063UHangar 22 Flying Club · Siren, WIBuilt 1965 · S/N 15061463 N4069UPch Transportation LLC · Monterey, CABuilt 1965 · S/N 15061469 N4073UNew Entity Corp · Hardy, ARS/N 15061473 N4075UWright Joseph G · Medicine Lodge, KSBuilt 1965 · S/N 15061475 N4076UKoehn David Scott · Orange Beach, ALS/N 15061476 N4077ECalef Jere Trustee · Mojave, CABuilt 1965 · S/N 15061477 N4078UHoover Michael B · Ridgeland, WIBuilt 1965 · S/N 15061478 N4079UScribner Jeffrey D · Upton, MEBuilt 1965 · S/N 15061479 N4083UKadlecovic Martin · Prescott, AZBuilt 1964 · S/N 15061483 N4085UHilderbrand Timothy S · Chicora, PABuilt 1965 · S/N 15061485 N4097UJ & K Flying LLC · Marengo, OHBuilt 1965 · S/N 15061497 N418WLShly Aviation LLC · Morgan, PABuilt 1965 · S/N 15061194

Back to Cessna 150E