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 ('2072431')
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 ('2072431')
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.
N736JESylvan Air Associates LLC · Lapeer, MIN736JFHartsuyker David L · Jackson, CAN736JHLloyd Stephen C · Erie, CON736JKMcfeaters Ryan C · Madisonville, TNN736JQRaven Limited · Seattle, WAN736JRMckibben Claude · Rochelle, ILN736JTRose Chris W · Rochester, NYN736JVRegistered aircraftN736JWHutcherson David R · Gretna, VAN736JYBorreson Anthony · Mariposa, CAN736KCGreen Robert W · Santa Barbara, CAN736KDAmts LLC · Pleasanton, CAN736KERegistration Pending · Cozad, NERegistration pendingN736KFEason Richard O · Orono, MEN736KNTurbine Financial Group LLC · Ogden, UTN736KPSutton Aircraft Salvage LLC · Palmer, AKN736KSRigfuel LLC · Eureka, MTN736KYSicheneder Scott A · Wasilla, AKN736LDSteinmeyer Peter A · Arvada, CON736LGM & R Aviation LLC · Fairview, ORN736LHDdjrrm Enterprises LLC · Plainfield, INN736LLSmith Matthew R · Thomaston, GAN736LMRaducu Radu · Bismarck, NDN736LPAlpha Kilo Aviation LLC · Wasilla, AKN736LVEggleston Kenneth W · Bethel, AKN736LWDrr Boonville LLC · Boonville, NYN736LXTaylor Tom M · Tulsa, OKN736MC3 Pandas LLC · Farmington, NMN736MDBrown Tyler Cooper Trustee · Anchorage, AKN736MFTurnagain Airventures LLC · Anchorage, AKN736MKDavis Rodger C · Anchorage, AKN736MLH & L Acquisitions LLC · Flushing, MIN736MNSeidler Matthew J · Anchorage, AKN736MPDarby Air Ltd · Lincolnshire, ILN736MTLowe John H · Tifton, GAN736MVMyers Aviation Inc · Oshkosh, WIN736MWWestern Radio Services Co · Prineville, ORN736MYLandry Cheryl A · Mendon, MAN736NCGully Justin T · Anoka, MNN736NEMahoney Daniel P III · Locust Grove, VAN736NFFhr Inc · Honolulu, HIN736NHCi Aviation LLC · Broadview Heights, OHN736NKMaine Air Physician Services LLC · Machias, MEN736NNM2 Aviation LLC · White Lake, MIN736NPMbn Leasing LLC · Dover, DEN736NQAs In The Key Aviation LLC · Marathon, FLN736NWG Force LLC · Las Vegas, NVN736NYTerry Mark Benjamin · Henderson, NCN736NZColey Steven J · Baker City, ORN736PBWoods Joyce M Trustee · Albuquerque, NM
Back to Cessna R172K