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 ('2071818')
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 ('2071818')
ORDER BY n_numberRun 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.
N7184SCade Steven V · Lopez, WAN7186SEagle Equity Inc · Valparaiso, INN7196SSale Reported · Taylorsville, MSSale reportedN7204SAerolab LLC · Hartwell, GAN7205SRegistration Pending · Dillingham, AKRegistration pendingN7207SRademacher Kenneth J · Cleveland, TXN7210SAccelerated Aviation Instruction LLC · Owatonna, MNN7215SHitt Bruce A · North Augusta, SCN7219STulsa Flight Training LLC · Bixby, OKN7223SSong David D · Ashland, CAN7225SAero States Aviation LLC · Owasso, OKN7226SN46132 Leasing LLC · Kalispell, MTN7228SMendoza William S · Antioch, CAN7233SHeidelberg Haley · Huntington, TXN7236SJanvrin Jerry M · Buffalo, SDN7237SMetcalf Rodney K · Jonesborough, TNN7238SExecutive Flight Institute LLC · Murrieta, CAN7245SHansen Abree G · Reno, NVN7246SDenton Christopher G · Youngsville, NCN7247SEpperly Scott E · Creswell, ORN7254SNickels Robert D · Fayetteville, TNN72579Allee Mark J · Gillette, WYN7257SFidalgo Flyers LLC · Anacortes, WAN7258SBusiness As Usual LLC · Spartanburg, SCN7259SSchafer Louis L · Murfreesboro, TNN725RBBatesole William D Trustee · Walpole, NHN7271SWalker Kevin · Stillwater, OKN7272SRegistered aircraftN7273SFerguson Jeffrey Woods · San Antonio, TXN7276SMorgan Michael · Wichita, KSN7277SMarkland Benjamin Harrison · Lehigh Acres, FLN7279SLee Peter Joohak · Irvine, CAN7282SDavis Patrick I · Acampo, CAN7283SMiller Bambi · Lee, NHN7285SHenry Mark A · Dickinson, TXN7286SMaychezak Lana R · Sentinel Butte, NDN7289SHancock Deborah M · Hayes, VAN7293SGraham John T · Phoenix, AZN7295SSpeedbird Ventures LLC · Driftwood, TXN7297SBukkila Joan E · Savage, MNN737KPPhill-Air Inc · Dover, DEN79425Legends Airways LLC · Lakeland, FLN80899Pedersen Herbert N · Willard, UTFirst renewal noticeN808KSDucks Are Free LLC · Salina, KSN8207BBodin Logan T · Lake Charles, LAN830JDMarlin David D · Conway, MON8436Higgins Ryan · Hellam, PAN8473GDyck David · Sumner, TXN864TGTouch N Go Aeroworks LLC · Greenville, SCN875MAGould Norman L Jr · Saunderstown, RI
Back to Cessna 150H