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 ('2072436')
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 ('2072436')
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.
N9846LCivil Air Patrol Inc · Maxwell Afb, ALN98477Registered aircraftN9847LJoerithan & Mp Aviation LLC · Whittier, CAN98485Amelia Reid Aviation LLC · San Jose, CAN98492Henry Mark Alan · Dickinson, TXN98494Noggle William L · Warthen, GAN9849LDynasty Adventure Inc · Wilmington, DEN98502Sky Warrior Flight Training Inc · Pensacola, FLN98525Trns Solutions LLC · Lewes, DEN98530Swan Aviation Ministries Inc · Crestview, FLN9853LTrend Vector Aviation Int · Barrigada, GUN98561Blue Sky Flight Training LLC · Hamilton, OHN98580Flying Farmers LLC · Clewiston, FLN98584Albritton Montana D · Honolulu, HIN98588Dunkle Douglas A · Dover, PAN98592Round-Out Aviation LLC · Owasso, OKN98637United States Air Force Owner · Elmendorf Afb, AKN9863LAspire Aviation LLC · Farmingdale, NYN98646Seitz David · Gordonville, TXN9864LCivil Air Patrol Inc · Maxwell Afb, ALN98651Milton Aviation Inc · Mohegan Lake, NYN98652Bartron J Stark III · Tunkhannock, PAN9866LNo Limits Aviation · Hayden, IDN98684Aviator Air Operations LLC · Grand Prairie, TXN98708Madera County Sheriffs Office · Madera, CAN98710Skywarrior Flight Training Inc · Pensacola, FLN98714Yellow Jacket Flying Club Inc · Chamblee, GAN98731Civil Air Patrol Inc · Maxwell Afb, ALN98738Bas Part Sales LLC · Greeley, CON98763Civil Air Patrol Inc · Maxwell Afb, ALN98769American Patrols Inc · Midland, TXN98772Solberg Aviation Co Inc · Whitehouse Station, NJN98774Simplifly LLC · Mesa, AZN98776Melbourne Flight Training LLC · Melbourne, FLN98792Stanzione Daniel F · Antelope, CAN98795Richmor Aviation Inc · Scotia, NYN98811Kadena Aero Club · Apo Ap, CAN98819Oxford Flying Club Inc · Oxford, CTN98824Civil Air Patrol Inc · Maxwell Afb, ALN98843American Patrols Inc · Midland, TXN98873Laguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeN9887LSkywarrior Flight Training Inc · Pensacola, FLN98887Jodkin Jason · Confluence, PAN98893Pape Jason C · Sykesville, MDN98913Civil Air Patrol Inc · Maxwell Afb, ALN98923Costa Flying Service Inc · Painted Post, NYN98954Emerson Solutions LLC · Bellingham, WAN98960Buiqui Aerospace Corp · Kissimmee, FLN98981Airplane And Drone Flight Instruction LLC · Orlando, FLN98987Civil Air Patrol Inc · Maxwell Afb, AL
Back to Cessna 172P