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 ('2072718')
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 ('2072718')
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.
N8432SCurzon Peter · Eugene, ORN8433SGregory Ovel Lee IV · Wayzata, MNN8435SFrancis David S · Lakeside, CAN8437SF & S Farms · London, OHN8438SMartin Gregory P · Fairbanks, AKN8439SRockwell Mark L · Fairbanks, AKN8440SHankins David B · Salome, AZN8446SInfanger Jim Bob · Salmon, IDFirst renewal noticeN8447SSteinheiser Terry N · Renfrew, PAN8449SHollensbe Brant W · West Des Moines, IAN8453SHarvey Paul E · Richmond, MEN8456SPalmer Jay H · Baraboo, WIN8458SSpielman Michael J · Reno, NVN8463SPjgrup Aviation LLC · Hollis, NHN8464SSinger Daniel J · Seneca, SCN8474SRichs Cadillac Truck Serv Inc · Cadillac, MIN8476SNomi Russell K · Bellevue, WAN8477SApache Air Service LLC · Helena, MTN8478SHemphill Holdings LLC · Hemphill, TXN8479SGreen Meadows LLC · Suphur Springs, TXN8481SQuigley Mark L · Nacogdoches, TXN8482STwin Cities Aviation Inc · Blaine, MNN8483SHolman David · Philip, SDN8486SCalton Thomas C · Rutherfordton, NCN8487SYoder Dwight D · Bear, DEFirst renewal noticeN8489SReading Michael P · Monee, ILN8490SHerring James N Jr · Nederland, CON8491SOgrin Kirk V · Bigfork, MTN8492SFlight Testers LLC · Seattle, WAN8496SOkon Randy W · Missoula, MTN8499SGraznak Timothy C · Greeley, CON8501SWitschger Scott L · Albuquerque, NMN8503SCub Club Inc · Toddville, IAN8505SAir Repair Inc · Cleveland, MSN8508S8508s LLC · Yerington, NVN8510SBarton Andrew · Morehead City, NCN8512SDoss Jacob · Casco, MIN8513SBeach Thomas C III · Salado, TXN8515SHawkins Kenneth Roger · Globe, AZN8516SReik Thomas Donaldson Jr · New Port Richey, FLN8517STardif Jean Y · Moorpark, CAN8519SCinden LLC · Nashua, NHN8520SClark Joseph D · Kilgore, TXN8524SLoyer Victor D · Palmer, AKN8528SLucas Robert I · Jackson, WYN8529SWollan David · Shelby, MTN8534SBorreson Anthony · Mariposa, CAN8536SClear Skies Aviation LLC · Reserve, MTN8539SFarmair Inc · Hughesville, PAN8545SRnr Aviation LLC · Malaga, WA
Back to Cessna 182H