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 ('2072704')
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 ('2072704')
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.
N6122BBendickson Tim T · Priest Lake, IDN6123BNeal Aircraft Inc · Slaton, TXN6124BShullanberger Ranch LLC · Lakeview, ORN6130BFandango Aviation LLC · Lake Elsinore, CAN6141BPayne Jacqueline · Minden, NVN6143BRushing Harley J III · Cheraw, SCN6144BRieser Robert · Aurora, ILN6146BMiles From Ordinary LLC · Auburn, WAN6147BMock David J · Mesa, AZN6151BCasey Ross H · Boise, IDN6154BChenoweth Lane Trustee · Anchorage, AKN6155BPelzer Michael J · Rochester Hills, MIN6156BRumple Richard A Jr · Angola, INN6160BJesperson Kenneth R · Ekalaka, MTN6161BPeterson Tony D · Humboldt, IAN6164B64 Bravo LLC · Oberlin, OHN6167BEdwards Darrell R · Artesia, NMN6168BSafety Source LLC · Kirkland, WAN6169BTjs Plane LLC · Renton, WAN6170BEnglish Stanley P · Anchorage, AKN6176BWitzel Colton J · Frenchglen, ORN6177BThomas Harry F Jr · Panama City, FLN6178BSeven Eight Bravo LLC · Billings, MTN6182BPipkin Chester L · Boise, IDN6186BConnelly William L · Lovell, MEN6191BValiair Lc Trustee · Casper, WYN6193BSmith Brian R · Avon, CTN6194BMaglaughlin Ronald D · Udall, KSFirst renewal noticeN6197BBarber James M · Oklahoma City, OKN6198BModel A Mlc LLC · Seattle, WAN6305BLeggett Bryce · Eola, TXN6306BGmr Leasing LLC · Lincoln, DEN6308BSnyder Kenneth Clayton · Lonsdale, MNN6309BDz Aviation LLC · Nephi, UTN6310BWilliams Clayton S · Mason, NHN6312BUsda Forest Service Fepp · Helena, MTN6313BLashbrooke Dana F · Durango, CON6314BGregg Delvin K · Durango, CON6315BEbright Sean E · Hasty, CON6323BJennett Cheryl K · Phoenix, AZN6327BNilsen Kim W · Hailey, IDN6329BN6329b Flyingclub LLC · Farmington, MNN632AHWrasse Mark R · Rosholt, WIN6333BEspiricueta William L · Denver, CON6334BS&D Spraying Service Inc · Panhandle, TXN6336BNorris Donald A III · Edmond, OKN6337BMckee Bradley Cole · Taylor, TXN6338BSlad George W · Albuquerque, NMN6344BJerome Buying Station Inc · Jerome, IDN6346BEasley John C · Eagle Rock, MO
Back to Cessna 182A