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 ('2072418')
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 ('2072418')
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.
N20621Bryant Jeffrey M · Pell City, ALN20626Swingle Craig A · Hopewell, OHN20634Jagoda William T Trustee · Rockfall, CTN20636Spencer Ted B · Meridian, MSN20637Dbj Aviation LLC · Venetia, PAN20648Jones Farm Fresh LLC · Bartlett, TNN20652H J H Aviation LLC · Gordo, ALN20660Jl Avn LLC · Ontario, OHN20665Millais Alan K · Sacramento, CAFirst renewal noticeN2066620666 Aircraft Leasing LLC · Spanish Fork, UTN20667Wojtowicz Diane L · Perry, NYN20668Safety In Motion Flight Center · Puyallup, WAN20670Stearns Edwin B Jr · Eloy, AZN20675First Flight Corp · San Diego, CAN20676Firstflight 33 LLC · Jacksonville, FLN20689Lessard Timothy F · Monmouth, MEN20693Celestial Kinetics Flight Academy LLC · Waupaca, WIN20697Schneidman Barry · Raleigh, NCN206MCPittock Troy · Fort Worth, TXN20714All American Aviation Services Inc · Wilmington, NCN20716Sargent Philip R · North Scituate, RIN20729Di Ludovico Leonard P · Leetonia, OHN20734Galegor Samuel T · Pleasant Hill, MON20742Iowa Lakes Community College · Estherville, IAN20745Van Wert County Regional Airport Authority · Van Wert, OHN20756Drew Kenneth R · Mineral Wells, TXN20763Meysenburg Daniel L · Columbus, NEN20770Trenkle Charles D · Long Beach, CAN20789Johnson Laurel D · Newcastle, WAN20792Boyette Donnie R · Kenly, NCN20804Ceddia Stephen J · Framingham, MAN20811Rtd Aviation LLC · Hillsborough, NJN20823American Patrols Inc · Midland, TXN20825Sussman Stanley M · New Castle, DEN20834Climb Maintain LLC · Morrisville, MON20837Mjm Enterprise Holdings LLC · Drexel, MON20843St Louis Flying Club Inc · Ellisville, MON20858Vintage Flyers Inc · Napa, CAN20865Agasair LLC · East Hampton, NYN20871High Flight Academy LLC · Allison Park, PAN20876Ogalalla Land & Cattle Ltd · Douglas, WYN20891Morristown Flying Service Inc · Talbott, TNN20921Brigham David F · Elliottsville Twp, MEN20932Registration Pending · Hammond, LARegistration pendingN20934Fly Skyhawk Llp · Galena, OHN20940Cirrus Flight Operations Inc · Minneapolis, MNN20951Strevels Stephen M · Knoxville, TNN20954Hardin John M · Terrell, TXN20965Reich Aviation LLC · Loudon, TNN20DKFlight Surgeon LLC · Fayetteville, AR
Back to Cessna 172M