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 ('7090453')
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 ('7090453')
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.
N413RKPilatus Aircraft USA Ltd · Broomfield, CON417FCGreenway Pc-24 LLC · Orlando, FLN425PCBlue Aviation LLC · Vineyard, UTN427SHSn163 LLC · Phoenix, AZN42MJPetit Michael · Dandridge, TNN457CGCreed Greg · Dallas, TXN499RKKansas City Aviation Center Inc · Olathe, KSN4WUWas-Up LLC · Boise, IDN502PSBcf Aviation LLC · Portsmoth, NHN506LKPilatus Aircraft USA Ltd · Broomfield, CON513PSRigi Inc · Portsmouth, NHN514FTFaith Technologies Inc · Menasha, WIN517LHLaboratory Corporation Of America Holdings · Burlington, NCN522YYBank Of Utah Trustee · Salt Lake City, UTN525AFBank Of Utah Trustee · Portsmouth, NHN528RN3js Air LLC · Smithfield, NCN52CPCutter Flight Management Inc · Albuquerque, NMN52MUS Fire Pump Equipment LLC · Holden, LAN533AFAlan Wire Co · Portsmouth, NHN542JBA & A Drug Co · Fremont, NEN551AFAltitude 900 LLC · Portsmouth, NHN555PJBixby Bridge Fund IV LLC · Northbrook, ILN556AFAppleby Management LLC · Portsmouth, NHN562DBShippy Aviation Az LLC · Apache Junction, AZN563SVEddies Legacy LLC · Clovis, CAN567SVTvpx Ars Inc Trustee · North Salt Lake, UTN56DLSwitchback Argentina LLC · New York, NYN576JAIa Aviation LLC · Savannah, GAN581EBBank Of Utah Trustee · Salt Lake City, UTN587JTLarkair 2 Inc · Clear Spring, MDN594AFAero 513 LLC · Portsmouth, NHN5FLN6fl LLC · Rancho Santa Fe, CAN601MZDel Norte Aviation LLC · Santa Teresa, NMN607AFAnderson Alexander Pllc · Portsmouth, NHN60JAArmstrong Airlines Inc · Dover, DEN620JKKelce Air LLC · New Castle, DEN621MNNewman Family Holdings LLC · Stanton, TXN621SVPilatus Aircraft USA Ltd · Broomfield, CON624SBZorba LLC · Sparta, MIN628HBValiair Lc Trustee · Casper, WYN629AFJones Dennis M Jr Trustee · Portsmouth, NHN631JCPilatus Aircraft USA Ltd · Broomfield, CON635AFAir Apparent Holdings LLC · Portsmouth, NHN644SMBpt Aviation LLC · Butler, PAN647AF2jc Corp · Portsmouth, NHN648SVPilatus Aircraft USA Ltd · Broomfield, CON649SGBank Of Utah Trustee · Salt Lake City, UTN650SVPilatus Aircraft USA Ltd · Broomfield, CON651AFPilatus Aircraft USA Ltd · Broomfield, CON652SVPilatus Aircraft USA Ltd · Broomfield, CO
Back to Pilatus PC-24