Skip to content

Registered aircraft · 1,439

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

N8792UBenair LLC · Bonita Springs, FLBuilt 1976 · S/N 15077996 N8794UMock Joseph R · Huntsville, TXBuilt 1976 · S/N 15077997 N8797USowers Harry D · S Bloomingville, OHBuilt 1976 · S/N 15077999 N8798UMimbach Mitchell J · Rice, MNBuilt 1976 · S/N 15078000 N87YThompson Jeff D · Tonasket, WABuilt 1975 · S/N 15075800 N8807UHarkins Robert W · Arnold, CAS/N 15078002 N8847URuo Hiko · Petaluma, CABuilt 1976 · S/N 15078003 N8850UA & H Renovation LLC · Woodstock, GABuilt 1976 · S/N 15078004 N8851UBaird Mark · Emeryville, CABuilt 1976 · S/N 15078005 N8853UDrakes Landing Inc · Archibald, LABuilt 1976 · S/N 15078006 N8855UBaginski D D · Salesville, OHBuilt 1976 · S/N 15078007 N8875UDunaire LLC · Mechanicsburg, PAS/N 15078009 N8878UBallard Ralph T · Hurricane, UTBuilt 1976 · S/N 15078011 N88808Thompson Patrick M · Madera, CABuilt 1974 · S/N 15076150 N8880UJackson Todd · Spirit Lake, IDBuilt 1976 · S/N 15078012 N8892UPropbusters Flying Club Inc · Wintersville, OHBuilt 1976 · S/N 15078014 N8894UMeyer Larry F · Brush, COBuilt 1976 · S/N 15078015 N8897URobison Stephen K · Frederick, MDBuilt 1976 · S/N 15078018 N8927URoberts Colton C · Bluebell, UTS/N 15078022 N8929UKrushinski Joseph M · Stafford, VABuilt 1976 · S/N 15078023 N8938UJofredo Corp · Zephyrhills, FLBuilt 1976 · S/N 15078024 N8954URausch John H · Fairport, NYBuilt 1976 · S/N 15078026 N8961UKqadvantage LLC · Orlando, FLS/N 15078031 N8963UAvia Aero Services Inc · Flagler Beach, FLBuilt 1976 · S/N 15078033 N8986UJmt Aviation LLC · Bel Air, MDBuilt 1976 · S/N 15078036 N8988UQuestair LLC · Madison, MSBuilt 1976 · S/N 15078038 N8992UCole Lawrence E · Willow Street, PAS/N 15078042 N8994UWahlberg Randy A · Pearland, TXBuilt 1976 · S/N 15078044 N8995UKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 15078045 N89HPMorgan Howard P Jr · Longmont, COBuilt 1975 · S/N 15077395 N9000UWhitaker Robbie L · Brooklet, GABuilt 1976 · S/N 15078050 N9004RHarper Edward A · Pleasant Plain, OHS/N 15076428 N9005UPea Patch Flying Club Inc · Girard, OHBuilt 1976 · S/N 15078051 N901UBowling Robert E · Argillite, KYBuilt 1974 · S/N 15076038 N902KSSmart Aviation Solutions Inc · Lakeland, FLBuilt 1974 · S/N 15076244 N903KSMbk Leasing And Consulting LLC · Lakeland, FLFirst renewal noticeBuilt 1975 · S/N 15076828 N9101UAura LLC · Elsie, MIBuilt 1976 · S/N 15078052 N9103UMonica Aviation LLC · Cambridge Springs, PABuilt 1976 · S/N 15078054 N9106USpafford Luke · Pontiac, ILBuilt 1976 · S/N 15078057 N9107UAnderson Christopher · Janesville, WIBuilt 1976 · S/N 15078058 N9108URegistration Pending · Studio City, CARegistration pendingBuilt 1976 · S/N 15078059 N9109UBrotherson Brian C · Independence, KYBuilt 1976 · S/N 15078060 N9111UKingdom Air Corps Inc · Sutton, AKBuilt 1976 · S/N 15078062 N9112UOstrander William P · Millerton, PABuilt 1976 · S/N 15078063 N9114UMarek John M · Tucson, AZBuilt 1976 · S/N 15078065 N9115UWigley Ben F Jr · Huntington, ORFirst renewal noticeS/N 15078066 N9117UBahr Timmy A · Crandon, WIBuilt 1976 · S/N 15078068 N9118U9118u LLC · Dover, IDBuilt 1976 · S/N 15078069 N9124USmith Stanley P · Athens, ALBuilt 1976 · S/N 15078075 N9128UHarrell Brian · Donalsonville, GABuilt 1976 · S/N 15078079

Back to Cessna 150M