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 ('2072502')
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 ('2072502')
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.
N7516MTobin Ardis C · Cheney, WAN7518MGearin Chad · Portland, ORN7520MWhitehurst Funeral Chapels Inc · Los Banos, CAN7522MJohanson Mark E · Ivins, UTN7523MW R Aviation Inc · Stigler, OKN7524MRange Shaun M · Brighton, MIN7526MHerning Benjamin N · Chugiak, AKN7527MGarfoot William K · Verona, WIN7534MChapman Maxwell A · Menasha, WIN7535MRegistered aircraftN7536MW R Aviation Inc · Stigler, OKN7537MKnox Larry D · Parachute, CON7539MBungalow Drug Inc · Belgrade, MTN7543MSwanson James E · O Fallon, MOFirst renewal noticeN7545MMurray Erwin L Jr DBA · Emporium, PAN7546MKress Carl M Jr · Newark, DEN7547MMcgovern Stephen M · Beaver Falls, PAN7549MWestrum Durl T · Norwalk, IAN7550MFulfer Richard S · Applegate, CAN7555MCamacho Daniel F · Lenexa, KSN7557MRegistration Pending · Warrensburg, MORegistration pendingN7558MPrice David B · Gallipolis, OHN7559MPatton Steven W · Fayetteville, ARN7560MShenk Mike D · Harper, ORN7564MAbkc LLC · Newark, DEN7565MLeaver Bros · Rossville, ILFirst renewal noticeN7570MBarreto Brian C · Lebanon, ORFirst renewal noticeN7573MToledo Oscar · North Bergen, NJN7574MStanphill Archie R · Lonoke, ARN7576MFender Steven D · Baltic, OHN7577MMorrow Scott · Sanbornton, NHN7578MSjeversen Michael D · Mora, MNN7584MPecotte Harry A · Silver City, NMN7586MStar Valley Aviation Club LLC · Afton, WYN7588MRucinski Edward A · Climax, NCN7590MLucci Giacinto A Jr · Nashville, MIN7600MTitan Construction LLC · Pinedale, WYN7604MVaughn David Rex · Spur, TXN7606MDellechaie Frank · South Lake Tahoe, CAN7608MInspiration Aviation LLC · Mesa, AZN7609MYoung Robert D · Georgetown, DEN7612MHall Adam Patrick · Borrego Springs, CAN7616MGriffin Robert L Jr · Washington, NCN7621MTorres Richard M · Valley Springs, CAN7628MSobutka John C · Hampton Falls, NHN7634MSutton Aircraft Salvage LLC · Palmer, AKN7636MPorter Bryan A · Deer Lodge, MTN7638MHerbert-Johnson Veronica L · Picayune, MSN7641MCrawford Trevor Nicolas · Potter Valley, CAN7645MKennedy Eric S · Utica, OH
Back to Cessna 175