Skip to content

Registered aircraft · 80

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

N100ULEvans Hugh E · Lafayette, LABuilt 1976 · S/N A1500634 N101MJRose Daniel · Cold Spring, NYBuilt 1974 · S/N A1500528 N150HCJones Luis · Las Vegas, NVS/N A1500725 N15CUSalvato Kyle · Key Largo, FLS/N A150-0692 N1914FCooke Thomas C · Greensboro, NCBuilt 1966 · S/N 15064970 N1975TCharnes Jonathan Edan · Elmwood Park, ILBuilt 1975 · S/N A1500587 N2714JRegistered aircraftBuilt 1974 · S/N A1500566 N2719JDewey Robert P · Ramona, CAS/N A1500568 N2721JDe Aviation Inc · La Porte, TXBuilt 1974 · S/N A1500569 N2725JQuinn Timothy · Bountiful, UTBuilt 1974 · S/N A1500572 N2728JWahlberg · Pearland, TXBuilt 1974 · S/N A1500573 N2731JPatry Aeronautical Institute · Kalispell, MTBuilt 1974 · S/N A1500574 N2734JHelbig Frederick E · Oakland, MDBuilt 1974 · S/N A1500576 N2739JCiulla Santo · Odessa, FLBuilt 1974 · S/N A1500578 N2745JRegistered aircraftBuilt 1974 · S/N A1500581 N2746JGelatt Joseph · Wasilla, AKS/N A1500582 N2758JSoutiere Theresa Yvette · Juneau, AKBuilt 1975 · S/N A1500588 N2759JNg Byron · Foster City, CAS/N A1500589 N2761JAldrich Curtiss R · Big Oak Flat, CAS/N A1500590 N2766JBedford Dennis · Auke Bay, AKBuilt 1975 · S/N A1500591 N2773JN2773j LLC · Titusville, FLBuilt 1975 · S/N A1500596 N2789JStephens Mark E Trustee · Morgan Hill, CABuilt 1975 · S/N A1500601 N2790JLock Robert Allen · Grand Haven, MIBuilt 1975 · S/N A1500602 N2791JPuget Sound Flyers Inc · Everett, WABuilt 1975 · S/N A1500603 N2798JCenter Of Gravity Flying Club LLC · Monterey, CABuilt 1975 · S/N A1500607 N515RVFlying Adventures Tm LLC · Talkeetna, AKBuilt 1975 · S/N A1500594 N67ABScaglia Bennett P · Port Orange, FLBuilt 1975 · S/N A1500599 N7315ATiny Sparrow Aviation LLC · Irvine, CAS/N A1500709 N7319AHart George · Yuba City, CAS/N A1500712 N7322ABaas Keith L · Alto, MIBuilt 1976 · S/N A1500715 N7327ACordova Coast Inc · King Salmon, AKBuilt 1976 · S/N A1500716 N7329ASargent Evan · Camas, WABuilt 1976 · S/N A1500717 N7335APomeroy Keith R · Port Saint Lucie, FLS/N A1500721 N7343ACheek Kenneth W · Yadkinville, NCBuilt 1977 · S/N A1500722 N7374ASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N A1500726 N7399AWheeler James H · Bryan, OHBuilt 1977 · S/N A1500731 N8092VRohm Arne · Miller, MOBuilt 1974 · S/N A1500526 N8121VValley Paul D · Lakeville, MNBuilt 1974 · S/N A1500530 N8142VKing Kevin J · Angle Inlet, MNBuilt 1974 · S/N A1500538 N8143VCenterline Holdings Inc · Camden, DEBuilt 1974 · S/N A1500539 N8144VLundahl Frederick B · Langley, WABuilt 1974 · S/N A1500540 N8146VAnthony Michael L · Sanger, TXBuilt 1974 · S/N A1500541 N8152VBrowning Lonnie O IV · Allendale, SCBuilt 1974 · S/N A1500543 N8172VStanford Jay J · Kingsland, GAS/N A1500553 N8175VTaylor Charles G · Knoxville, TNBuilt 1974 · S/N A1500555 N8185VCryan Mark · Port Orange, FLBuilt 1974 · S/N A1500557 N8187VNelson Brett R · Shoreview, MNBuilt 1974 · S/N A1500559 N8195VHigh View Air LLC · Driftwood, TXBuilt 1974 · S/N A1500564 N9795VWilliams Bob L · Udall, KSS/N A1500565 N9800JButts James Allen · Gainesville, GABuilt 1975 · S/N A1500609

Back to Cessna A150M