Skip to content

Registered aircraft · 176

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

N6008DChristopher D Bock · Fishers, INBuilt 1979 · S/N MC-611 N6008URasmussen John E · Seffner, FLBuilt 1978 · S/N MC-616 N60097Ratliff Frank O · Palestine, TXBuilt 1978 · S/N MC-619 N6011JSymond Clarence B · Eastover, NCBuilt 1978 · S/N MC-625 N6014LIrsfeld Matthew T · Kingman, AZS/N MC-628 N6016KRamsey Keith W · Morrison, TNS/N MC-646 N6016YClute Jack S · Valparaiso, INBuilt 1979 · S/N MC-650 N6020PClark Katherine A · Spring, TXBuilt 1979 · S/N MC-653 N6021PPullman Eric B · Wurtsboro, NYBuilt 1979 · S/N MC-657 N6022MWolf Richard J · Apple Valley, CABuilt 1979 · S/N MC-654 N6041XRegistration Pending · Solvang, CARegistration pending, pending cancellationBuilt 1979 · S/N MC-656 N6042ULion Facility Engineering Consultants LLC · Inyokern, CABuilt 1979 · S/N MC-659 N60433Texas Triple Net Gp LLC · Austin, TXBuilt 1979 · S/N MC-661 N6044DBuckingham Brian L · Fletcher, NCBuilt 1979 · S/N MC-662 N6044ESuperstar Aog LLC · Tallahassee, FLBuilt 1979 · S/N MC-664 N6047ULarson John Howard · Kerrville, TXBuilt 1979 · S/N MC-667 N61018Grimes Richard Reid · Hoover, ALBuilt 1982 · S/N MC-776 N615VMBas Part Sales LLC · Greeley, COBuilt 1977 · S/N MC-480 N6164CN6164c LLC · Baker, LABuilt 1981 · S/N MC-769 N620SSSciscoe William D · Dish, TXS/N MC-785 N62819Flying Monkey LLC · Pinckney, MIBuilt 1982 · S/N MC-772 N62BVTichy John M · Long Bch Twp, NJBuilt 1979 · S/N MC-649 N63039Riberdy Andrew L · Colebrook, CTBuilt 1982 · S/N MC-778 N6326UKilpatrick Bryan J · Poway, CABuilt 1982 · S/N MC-774 N6339XBarnes Gary P · Phoenix, MDBuilt 1982 · S/N MC-775 N63576Kronsbein Peter M A · Charlotte, NCBuilt 1982 · S/N MC-780 N63893Hurley Matthew · Brooklyn, NYBuilt 1982 · S/N MC-787 N6521NPerkins Marcus · Ridgeville, SCBuilt 1982 · S/N MC-779 N6536CWilliamson Michael A · Bend, ORBuilt 1983 · S/N MC-788 N6628DSummer Air LLC · Greenville, SCBuilt 1979 · S/N MC-672 N66293Maine Instrument Flight · Augusta, MEBuilt 1979 · S/N MC-674 N66303Holder Real Estate Services LLC · Pembroke, KYBuilt 1979 · S/N MC-676 N66304Schandelmeier Charles E · Melissa, TXBuilt 1979 · S/N MC-675 N6634MSherwood Matthew M · Independence, MOBuilt 1979 · S/N MC-682 N6634XPierson Rodney K Trustee · Redding, CABuilt 1979 · S/N MC-685 N6635DGooderum Mark P · Excelsior, MNBuilt 1979 · S/N MC-668 N6636DAnderson James M · Little Rock, ARS/N MC-690 N6637EOddo Dominick · Mahopac, NYBuilt 1979 · S/N MC-692 N6637ZTye Barry · Opelika, ALBuilt 1979 · S/N MC-693 N66433Mc Namara Donald · Sunriver, ORBuilt 1983 · S/N MC-791 N6651TMichalina Patrick J · Liberty Hill, TXBuilt 1982 · S/N MC-784 N6656APike/Kelley LLC · Eureka Springs, ARBuilt 1983 · S/N MC-792 N6682THanger 32 LLC · Largo, FLBuilt 1983 · S/N MC-786 N66912Mcintyre Daniel J · Bristol, CTS/N MC794 N6697ZFlying Realtor LLC · Jamaica, NYBuilt 1979 · S/N MC-695 N6698EGr3en Inc · Honolulu, HIS/N MC-697 N6698FHarding Michael D · Orlando, FLBuilt 1979 · S/N MC-698 N6703PShook Andrew Parker · Mountain Brk, ALBuilt 1979 · S/N MC-703 N67056Bonner William B · Fort Worth, TXBuilt 1980 · S/N MC-731 N6706DQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N MC-705

Back to Beech C24R