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.
N8971VGibson Aviation Services LLC · Hudson, WIN8972VPearce Michael J · Phoenix, AZN8973VOcean Flyers LLC · Chatham, NJN8975VMauser James E · Zionsville, PAN8979VAvel Aircraft Inc · West Chicago, ILN8980VSweitz-Air Inc · Stewartstown, PAN8982VHirsch John K Trustee · Gerald, MON8983VMoon Reagan E · Bossier City, LAN8986VAirline Transport Professionals Corp Of USA · Wilmington, DEN8987VPiper Capital Growth Fund LLC · Scottsdale, AZN8988VWahle Daniel C · Missoula, MTN8992VFreeze Otis C · Frankston, TXN8993VBmg Aviation Leasing LLC · Bloomington, INN8996VBaumgartner Scot W · Colby, WIN8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEN89KAKenmore Air Harbor LLC · Kenmore, WAN8FYMacauley Edwin T · White City, ORN8QCKaiser Paul A · Juneau, AKN9002HAngel Aviation Inc · Peoria, AZN9005HBuffalo Aviation LLC · Royal, NEN9009HConnell Flying Service Inc · Decorah, IAN9012HLeading Edge Flight Academy LLC · Bend, ORN9014HFlex Air Holdings Inc · Manhattan, KSN9017HMeece Harvey T · Somerset, KYN9027HAdriatic Holdings LLC · Cheyenne, WYN9038HPeterson Todd B · Cameron Park, CAN903NSAmerican Patrols Inc · Midland, TXN9042HSt Pete Aviation Services LLC · St Petersburg, FLN9043HPinter Seth K · Abbotsford, WIN9048HGravesen Mark A · Kenmare, NDN904RAJw Aero Holdings Inc · Canandaigua, NYN9057HAmoroso Ricardo C · Powder Springs, GAN9060HJ&S Flying Enterprises LLC · Zanesville, OHN9068HGundlach Mark A · Fruitland, WAN907TTHangar Ak LLC · Sterling, AKN9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJN9089HDavis Joseph S · Andalusia, ALN9091HCampbell Raymond · Box Elder, SDN9092HWinemiller Stevie Dale · Swifton, ARN9096HCallaway Mary Ann · Homedale, IDN909VCSan Bernardino Community College District · San Bernardino, CAN9100HHastings Stephen J · Palmer, AKN9106HLapenna Mark A · Madison, INN9107HChm Aviation LLC · Wilmington, DEN9109HJunior Coal Contracting Inc · Philipsburg, PAN910PFCertified Aviation LLC · Morristown, NJN9110HSierra Aero LLC · Truckee, CAN9114HRohwer Michael G Trustee · Tucson, AZN9120HKrieg Kristi · Tonasket, WAN9121HTwenty-One Flyers Inc · Norwalk, CT
Back to Cessna 172M