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 ('0690009', '060009Y', '05622D3')
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 ('0690009', '060009Y', '05622D3')
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.
N5521Schroder Randall L · O Fallon, MON562EGaulden Gerald M · Mc Caysville, GAN563STMiller Frederick J Trustee · Bucyrus, OHN564AJHarrison G Peter · Mechanicstown, OHN571ZJohnson Edwin G · Winnabow, NCN572LSYakis Levonte L · Gervais, ORN574RWGraves Richard W · Beaverton, ORN577RVTessitore Anthony P · Lacey, WAN5795TKopeika Robert C · Evergreen Park, ILN57RDPortner Jeff H · Blue Bell, PAN587RSStark Ryan L · Fort Wayne, INN588DFShade Neal Martin · Columbia, TNN58CVApa LLC · St George, UTN5941CHuff Roger A · Johnstown, OHN599CWFong Chee Wei · Broomfield, CON602TTLittell William M · Norwell, MAN603NHMekler Alan · Gilford, NHN605DRees Chad A · Tucson, AZN607JHHand Mickey James · Painted Post, NYN609SJHill Robert A · Katy, TXN611RDGoellner Harold J · Poplar Grove, ILN611VBBudget Leasing Company Inc · Orem, UTN612JVVan Grunsven Gerald B · Hillsboro, ORN612PCClaar Patrick S · Arvada, CON612RVJacobson Kara L · Atlanta, GAN612VABoatright Lee A · Potter Valley, CAFirst renewal noticeN614AKPerucca Nicholas H · Colorado Springs, CON614CEEastlake Charles N · Port Orange, FLN616TMarx Randal A · Ignacio, CON6174Kayle Gregg E · Wilsonville, ORN618BBahrns Phyllis Alyene · Effingham, ILN619RVMillhouse David S · Madison, ALN61VMMatulja Vincent K · Columbus, OHN620DSSchoenberg Dennis P · Bend, ORN623RVChastain George P · Haslet, TXN624ESHaley Michael · Menifee, CAN624RVMisage Mark A · Austin, TXN628GKSprague Joseph W · Morganfield, KYN628JHHolmgreen John B · Osseo, WIN632PSBoerner Dewayne · Litchfield Park, AZN633CMStricker James C · Hinckley, OHN643ARShippee Ronald L · Severn, MDN647RMEmmons Dale P · San Francisco, CAN650AKMarchant Keith H · Springfield, ORN650KWFly Kilo Whiskey LLC · Sun City West, AZN651MFGrier Alan T · Livermore, CAN654RHuizenga Randal L · Orland Park, ILN657GBBraun Glen C · Lake Stevens, WAN65JWAircraft Owners And Pilots Association · Frederick, MDN6699ZRegistration Pending · Montezuma, KSRegistration pending
Back to Vans RV-12