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 ('2072703', '2072707', '2072705')
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 ('2072703', '2072707', '2072705')
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.
N33HARykris Investments LLC · Bowling Green, KYN344CACivil Air Patrol · Maxwell Afb, ALN345TJOpa Flys LLC · Magnolia, TXN348TCWilliams Ryan D · Panama City, FLN3500FN3500f LLC · Jennings, LAN3500MNagy Sandor · Monterey, CAN3503HRansom Woodbury S Trustee · Lansing, IAN3506QEjair LLC · Shelburne, VTN3511FHardison Charles M · Granbury, TXN3513TCrusade Investments LLC · Ardmore, OKN35183Stone Industrial Contractors Inc · Savannah, GAN35184Maliszewski William F · Independence, WIN35188Landsearch LLC · Wilmington, NCN351CPCivil Air Patrol · Maxwell Afb, ALN3521KState Of North Carolina · Raleigh, NCN3524FRegistered aircraftN3525RCrabtree Jeremy Adam · Atlantic Beach, NCN3528CAlvarez Fernando Perez · Santan Arecibo, PRN3528DBank Of Utah Trustee · Salt Lake City, UTN35291Rochon Everette · Wesley Chapel, FLN3529NOken Andrew · Corvallis, ORN352CPCivil Air Patrol · Maxwell Afb, ALN3532KHattell George Curtis · Olympia, WAN353CPCivil Air Patrol · Montgomery, ALN3541AFogle Douglas J · Valparaiso, INN3542BHuddleston James A · Eloy, AZN3543HMagness Thomas W · West Chester, PAN3545JBarr Air Patrol LLC · Mesquite, TXN3546HOdonnell John Merritt · Kennebunkport, MEN3548MSpenser Air LLC · Starkville, MSN3548SSunny Skies Aviators LLC · Vernal, UTN354CPCivil Air Patrol · Montgomery, ALN3552DBarwick H Brooks III · Clinton, NCN3552L4wblue LLC · Waccabuc, NYN3552QRegistered aircraftN3556VWestbank Fishing LLC · Kiln, MSN3559EGreater Flint Pilots Association Inc · Flushing, MIN3559RWest Indies Aviation Corp Trustee · Wilmington, DEN355CPCivil Air Patrol · Maxwell Afb, ALN356BFRegistered aircraftN356CPCivil Air Patrol · Maxwell Afb, ALN357CPCivil Air Patrol · Maxwell Afb, ALN357HMH & M Aviation LLC · Madison, MSN358CPCivil Air Patrol · Maxwell Afb, ALN359CPCivil Air Patrol · Maxwell Afb, ALN359TWDouble Bogey Aviation LLC · Midland, TXN360CPCivil Air Patrol · Maxwell Afb, ALN361DBLcb Leasing · Manassas, VAFirst renewal noticeN365CACivil Air Patrol · Maxwell Afb, ALN365WCCrane Douglas F · Ukiah, CA
Back to Cessna 182T