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 ('2072434')
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 ('2072434')
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.
N74CPersonal Aviation Inc · Poway, CAN74ERSimplifly LLC · Mesa, AZN75013Frank Technologies Inc · Venice, CAN751BKGeneral Aviation LLC · Henderson, NVN75513Baird David J · Mount Shasta, CAN75515N75515 LLC · Palm City, FLN75516Morristown Flying Service Inc · Talbott, TNN75518Cloudhop LLC · Pinehurst, TXN75522Bradley Alexander L · Chesapeake, OHN75529Jmw Skyhawk LLC · Midland Park, NJN75531Garner Michael A · Hernando, MSN75532Darrow William A · Guthrie Center, IAN75535Skyhawk Cowboys LLC · Port Angeles, WAN75536N75536 LLC · Palm City, FLN75537Jimenez Carlos · Davie, FLN75538Mike Moser Inc · Wilmington, DEN7553EPolley Terri J · San Antonio Height, CAFirst renewal noticeN75548Mcfadden Edward C · Ferris, TXN75549Matthews Raymond H Jr · Rhoadesville, VAN75555American Patrols Inc · Midland, TXN75559Gillanders Robert Ross Personal Representative · Gig Harbor, WAN75560Nexga Aircraft Inc · Greensboro, NCN75565Flight 915 LLC · El Paso, TXN75566Wilson Robert J · Annville, PAN75571Kohls Bruce P · Melbourne, KYN75572Bean Keith Owen · Glenwood, IAN75575Mayo William J Jr · Reed Point, MTN75586Adventist World Aviation · Wilson, NCN75587Ullah Muhammad K · Federalsburg, MDN75588Emry Scott D · Brookings, ORN75590Burgess Wayne R · Brown City, MIN75591Reynolds Darryl G · Wills Point, TXN75596Christian Charles R · La Crescenta, CAN75598Columbia Jet Center Inc · Columbia, MON75600Airspeed Marketing LLC · Phoenix, AZFirst renewal noticeN75601Sierra Corp · Worthngtn Spg, FLN75602Jkg LLC · Murfreesboro, TNN75603Riexinger Keith D · Ellensburg, WAFirst renewal noticeN75605Miller Mark · Atascadero, CAN75608Albertson Michael D · Greenwood, SCN7560DJiang Jun · Fremont, CAN75611Ocala Aviation Services Inc · Ocala, FLN75612Difonzo Pete A · New Windsor, MDN75615Star Av8r LLC · Austell, GAN7561ELichodziejewski David J · Fountain Valley, CAN75620Nitta Jeffrey M · Waipahu, HIN75621Turo Ron · Mt Holly Spgs, PAN75626Fanning James F · Palm Coast, FLN75628Apm Leasing LLC · Casper, WYN7562FGreen Airports Development Corp · Kemah, TX
Back to Cessna 172N