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.
N738JPHaskins Robert A · Salinas, CAN738JSWings Over Texas Holdings LLC · Denton, TXN738JTNorthwoods Air LLC · Orono, MEN738JULlano Masonry LLC · Lubbock, TXN738JWAllen Stephen R · Ventura, CAN738JXSuperior Flying Services LLC · Superior, WIN738KAFlying Aces Aero Fleet Inc · Guyton, GAN738KCCarter Flygare Inc · Sacramento, CAN738KFShouling & Philip Enterprise · Lancaster, CAN738KG738 Kilo Golf LLC · Southern Shores, NCN738KJFly Compton Aeronautical Education Foundation · Compton, CAN738KKSpradley Amanda · Greenwood, SCFirst renewal noticeN738KPJupiter Flight Service And Investing LLC · Lithonia, GAN738KQYeomans James S · Harvey Cedars, NJN738KTGetaway Aviation LLC · Spring Lake, MIN738KUBoehmlehner Steven A · Rosholt, SDN738KWAvetrani Jose A · Miami, FLN738LCCruise Flight Academy Inc · Dalton, GAN738LGSchultz Leesa · Mesquite, NVN738LHLh Enterprise LLC · Eads, TNN738LMBlack Bear Aviation LLC · Scottsdale, AZN738LNSidor David R · Palm Desert, CAN738LVUrban Aviation Services Inc · Paxton, MAN738MCMoore Michael E · Shawnee, KSN738MEN738me LLC · Miami, FLN738MHCurtis Creek Aviation LLC · Kalispell, MTN738MJOptic Air LLC · Sioux Center, IAN738MKObrien Aviation Inc · Port Orange, FLN738MLSouthern Wings Aircraft Sales Ltd · Bethany, OKN738MRNew World Air LLC · Orland Park, ILN738MTJulep Arbor Flying LLC · Salisbury, NCN738MWN738mw LLC · Jupiter, FLN738MZCarrasco Alonzo · Burleson, TXN738NBLele Aviation LLC · Denver, CON738NCAndrosky Mark J · Superior, WIN738NDFood From The Forest LLC · Wilmington, DEN738NGMusson Jeffrey L · Racine, WIN738NHUS Navy Commander Navy Installation Command · Millington, TNN738NKAscutney Air LLC · Claremont, NHN738NMRegistration Pending · Burlington, WIRegistration pendingN738NNAero Aviation LLC · Long Beach, CAN738NTChamberlain Sheldon L · Patterson, LAN738NUAeroflyin Corp · Miramar, FLN738NXAbove All Aviation Inc · Goleta, CAN738NYMonmouth Area Flying Club Inc · Lakewood, NJN738PDMontgomery Robert E · Fairfax, VAN738PHStroemsvik Kristian · Strasburg, VAN738PJGeebee Ventures LLC · Belgrade, MTN738PMDaviation Inc · Willoughby, OHN738PNPapa November LLC · Orlando, FL
Back to Cessna 172N