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 ('5870208')
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 ('5870208')
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.
N6469USoares Marcus K · Boca Raton, FLN6473UCardinal Exploration LLC · Northville, MIN6475UVermilyea Ian · Pensacola, FLN6476UFoster William B Jr · Chickasha, OKN6479UCm Aviation · Del Rio, TXFirst renewal noticeN6483UFalk Edward A · Seattle, WAN6486UDof Aviation Inc · Schertz, TXN6487UScheifele Gay F · Derwood, MDN6488UWings Leman F · Richmond, CAN6491UAllen Todd C · Abingdon, VAN6495UOtto David L · Lacey, WAN6496UWeaver Jimmie G · Winston Salem, NCN6497UPointer James E · Cumming, GAN6499USolley Richard T · Mott, NDN64JLMay Michael W · Billings, MTN6500UWhitson Mark A · Houston, TXN6505UBell Keith O · Navarre, FLN6506ULambert Isabelle O · El Paso, TXN6507UBovey Dominic C · Sandpoint, IDN6512UWilliams Larry M · Midland, NCN6513UKendall Keven S · Logan, UTN6515UFuller Spencer A · Lake Balboa, CAN6517UNova Accounting LLC · Herndon, VAN6518UWhetzel Peter W · Mathias, WVN6519USherr Steven · Mandan, NDN6520ULundquist Justin Carl · Sarasota, FLN6524UPangoavia Inc · Wilmington, DEN6525UFreeman Christopher D · Kingsbury, TXN6526UShaffer Ernest Glenn · Vinemont, ALN6529UMidwest Mooney Flyers LLC · Indianapolis, INN6530UHeidelberg Haley · Huntington, TXN6534UHuertas Andrew · Van Nuys, CAN6541URegistered aircraftN6543UGiesey William · Philadelphia, PAN6546UBadlands Flyers Inc · Watford City, NDN6550UGeorge Ladelle L · Ashley, NDN6551UAuker Donald · Lebanon, PAN6552UGoldstein Meyer · Underwood, WAN6553ULewis Orville W II · Memphis, TNN6556UQoc Innovations LLC · Fall River, WIN6557UAtalla Mark S · Woodford, VAN6558UReed Gina D · Starkville, MSN6560UTeaford Kris K · Berryville, VAN6561UJones Charles · Mountain Grove, MON6562UTaquara LLC · Ridgewood, NYN6563UCard Damon · Chicago, ILN6564UK & S Aviation LLC · Harrisburg, PAN6565UTherriault Thomas · Avondale, AZN6567UDonnelly Lewis J · Warwick, NYN6568UHowell Larry A · Terrell, TX
Back to Mooney M20C