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.
N256VAOkikawa Ricky · Sacramento, CAN257BBWarner William S · Medford, ORN257HSHines Steven T · Redding, CAN257VAPacific Flight Academy LLC · Honolulu, HIN257WPRobinson Darrin P · Leicester, NCN259VASnowbird Aviation Corp · Signal Mountain, TNN261VAM&J Aircraft Services LLC · Frederick, MDN262VAUt Lightsport One LLC · Riverdale, UTN263VADemas Larry R · Vienna, VAN264VACarlberg William C Jr · Gilbert, AZN265RSSwamp Fox Aviation LLC · Wilmington, DEN265VAEverett Reginald W · Trapper Creek, AKN266TFGravely Bryan Landon · Bonney Lake, WAN266VAChi Aerospace Inc · Portsmouth, NHN267AFDelaney Claudia A · Garden City, IDN267VANiculescu Marius · Bothell, WAN268VABasel Scott D · Petoskey, MIN270MZZimmerman Thomas L · Escondido, CAN270VAGrays Rd Aviation LLC · Wilmington, DEN271RLEigsti Rodney · Friend, NEN271VAChi Aerospace Inc · Portsmouth, NHN272VAFp Aircraft Holdings LLC · Alvord, TXN273VAPatterson Gaston R · Rathdrum, IDN274VABaugh Matthew L · La Conner, WAN275WEAdams Robert · Boise, IDN277VAHomburg Felix · Miami, FLN279LHLoftus Kelly J · Grass Valley, CAN279VACampbell Howard D · Magnolia, TXN27VCRv-12 LLC · Glendale, AZN284DGSmith Curtis A · Urbana, OHN285TYYost Thomas A · Keaau, HIN28BSSirani Aviation · Oasis, IDN29199Wilson Russell L · Martinsville, INN2932Spillman John Lee · Helotes, TXN295KWest Michael R · Navarre, FLN29CXHays William D · Frederick, MDN29WBWoolard Katherine B Trustee · Greenbrae, CAN2ETWall Andrew · Alto, GAN300DKKennedy Donald J · Ventura, CAN301VARiebe Robert D · Caldwell, IDN302BJFort Smith Flying Club Inc · Fort Smith, ARN304EJPizzo Duane G · Warren, ORN304JMHorta Miguel Angel · Hialeah, FLN307VABalski Keith D · Medina, OHN308VAChesapeake Searey LLC · Wilmington, DEN311VA08i Aerospace Inc · Portsmouth, NHN312ELucia Jim · Prescott, AZN312KRRandles Kenneth H · Grant, ALN312MKBroussard Steven J · Youngsville, LAN312MZZiermann Marlin R · Mayer, MN
Back to Vans RV-12