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 ('2075816')
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 ('2075816')
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.
N6322FKamp LLC · Kalispell, MTN6330FHansen Jodi L E · Farmington, MNN6340FCommonwealth Of Massachusetts · Plymouth, MAN6341FChronister Rex · Fort Smith, ARN6348FHiebert Marvin R · Yelm, WAN6349FHanes Stephen A · Albuquerque, NMN6358FHarrison Zuzana · Albuquerque, NMN6389FSymms Fruit Ranch Inc · Caldwell, IDN6394FScowden Wendell R · Piketon, OHN6395FSalisbury Neilan · Trabuco Canyon, CAN6397FCrosby Dennis L · Foley, ALN6404FHigh Demand Earthworks & Vineyard Development LLC · Napa, CAN6415FDewitte Jon James · Bishop, GAN6444MMccoy Thomas F · Sperry, OKN6455FSan Copertino LLC · Rome, GAN6472GMiralou Aero LLC · Pittsburgh, PAN6479FFurick Robert P · Woodinville, WAN6493FHatcher Jess · Lehi, UTN6496FFisher Justin T · Lewes, DEN6499FMacintosh William J · Simpsonville, SCN64TJRcs Farms Inc · Hereford, TXN6504MSobien Andrew J III · Mountain Home, IDN6506MBeechhurst Corp · Wilmington, DEN6519MWarar Manjit S · Shreveport, LAN6525MStene Nathanial S · Waterloo, NEN6530MTschann David M II · Yorba Linda, CAFirst renewal noticeN6534MJcj Aero LLC · Star, IDN6535MLodwick Kristopher O · Steamboat Springs, CON6536MSmith Brian L · Lake Oswego, ORN6541MAero Adventures Of Ms LLC · Hazlehurst, MSN6547MLeder John · Marble, NCN6549MWhitinger Ryan · Flowery Branch, GAN654ASDwyer Sean · Edmonds, WAN6552MLanman Inc · Litchfield, ILN6557MHenderson Douglas A · Cape Coral, FLN6560MCopich John J · Youngstown, OHN6561MMcgovern Thomas F · Dagsboro, DEN6565MLucier Jared · Decatur, TXN6568MDickson Joshua · Frankfort, MEN6569MBrown George P III · Houston, TXN656EMAxis Electric Inc · Albany, ORN6570MJones Brandon · Steele, MON6582MHayward W Blair · Brooks, GAN6583MParnell Kevin T · Buhl, IDN6590MOpm Holdings LLC · Wilmington, DEFirst renewal noticeN6594MRayburn William E · Oak Harbor, OHN6596MEjs Enterprises Inc · Three Forks, MTN6599MSieben Livestock Co · Helena, MTN659BPArnold Airplane LLC · North Branch, MNN6601MOptical Aviation LLC · Edmond, OK
Back to Cessna 182P