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 ('2072730')
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 ('2072730')
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.
N8969GGaluska Matthew · Minnetonka, MNN8972GDay & Night Plumbing & Heating LLC · Sidney, NEN8973GGough John C · Gooding, IDFirst renewal noticeN8974GPike Vincent I · Bagdad, AZN8976GTeeray LLC · Mountain City, TNN8992GKing William · Tallulah, LAN8994GRussmann Nicholas S · Merit, TXN9006GAltomari Richard J · Pittsburgh, PAN9007GKem Air Enterprises LLC · Kalispell, MTN9012GCockrell Carroll G · Mount Sterling, KYN9016GSkydive Duluth Superior LLC · Superior, WIN9018GSimpkins Lynn DBA · Costa Mesa, CAN9020GAmeritek LLC · Tuttle, OKN9021GRector Edward L · Nederland, TXN9023GBull Bren C · Kingsville, TXN9024GJessop Jacob N · Cedar City, UTN9025GN9025g LLC · Indianapolis, INN9026GTekoa Skylane Club · Chattaroy, WAN9027GCessna Flyers LLC · Spartanburg, SCN9033GHillside Air Service LLC · Roanoke, INN9034GDanielle K Heckman · Crystal River, FLN9035GRd Smith LLC · Rexburg, IDN9045GSkyview LLC · Omaha, NEN9050GOneal Gary L · Springdale, ARN9051GMid Continent Aircraft Corp · Hayti, MON9059GElevated Aviation LLC · West Plains, MON9060GWalther Newell A · Wasilla, AKN9064GEvans Brandon Ks · Montgomery, ALN9074GRush Wayne A · Troy, KSN9079GHenriksen Gary L · Sequim, WAN907PBMorris Engineering Group Inc · Auke Bay, AKN9081GIfr Investments LLC · Covington, LAN9085GHatley Ralph A · Eagle Creek, ORN9086GWilcox Leo Morgan · Winnie, TXN9087GHigh Planes LLC · Carter, MTN9093GThomas Kent · Wilsonville, ORN9094GRicks Thomas C · San Carlos, CAN9097GScharping Glenn Alan · Whitelaw, WIN9099GRegistration Pending · Edmond, OKRegistration pending, pending cancellationN9101GTregellas Cattle LLC · Perryton, TXN9103GAdkins Bruce M · Westfield, NJN9108GLeder John A · Marble, NCN9109GVess David G · Gaffney, SCN9112GPomeroy Vincent Lee · Anchorage, AKN9116GJones Brian E · Painted Post, NYFirst renewal noticeN9117GAndrews Mimi Muldrow · Hilltop Lakes, TXN9119GWinters Richard Linn · Chandler, AZN9120GRoderi Air LLC · Berlin, MDN9126GJfh-Air LLC · Dayton, OHN9134GHoworth Earl J · Gainesville, GA
Back to Cessna 182N