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 ('3371604')
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 ('3371604')
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.
N49830Mitchard John J · Sherrills Ford, NCN50024Mid Atlantic Air Museum Inc · Reading, PAN50341Hooey Kevin M · Corning, NYN50420Cutigni David L · Spencerville, INN50426American Airpower Heritage Flying Museum · Dallas, TXN50429Aircraft Registration Inc Trustee · KematenN50481American Airpower Heritage Flying Museum Inc · Dallas, TXN50809Dudley Denise M · Santa Margarita, CAN51173American Airpower Heritage Flying Museum · Dallas, TXN51263American Airpower Heritage Flying Museum · Dallas, TXN51625Olten Elmer Jr · Wright City, MORevoked, canceledN51628Manning Philip J · Melbourne, FLN51690Laurito Patsy · Pittsburgh, PARevoked, canceledN51874Patchett James J · Chapmansboro, TNN51939National Museum Of World War II Aviation · Colorado Springs, CON52159Spence Justin A · Memphis, TNN5215ZAmerican Airpower Heritage Flying Museum · Dallas, TXN52567Cadet Air Corp Museum · Tarkio, MON52860Morton John C · Brewster, NYN52913Brown Charles T · Jackson, GAN53019Pflegl Henry A · Oregon City, ORN53288Razorback Eaa 1388 · Pine Bluff, ARN53656American Airpower Heritage Flying Museum · Dallas, TXN53660Moon Brittany Lozier · Noblesville, INN53727Oaks Randall K · Oxnard, CAN53848Chumbley Eric M · Alvaton, KYN53929Wynecoop Shawn R · Bowbells, NDN53953Wilson Tommy · Greenleaf, IDN54201Casa Acquisitions LLC · Winter Haven, FLN54508Rare Aircraft Ltd · Faribault, MNN54712Brakefield Alan C Trustee · Washington, OKN54714Hagerstown Aviation Museum Inc · Hagerstown, MDN54801National Museum Of World War II Aviation · Colorado Springs, CON54869M/T Flyers LLC · Hayes, VAN54901American Aviation Heritage Foundation Inc · Blaine, MNN54977Port Townsend Aero Museum · Port Townsend, WAN56106Riffle George W · Auburn, WAN56216Moore George C Sr · Fincastle, VAN56268Western Antique Aeroplane & Automobile Museum · Hood River, ORN56409Burkel Robert G · Hemet, CAN56563Hiner Kirk J · Kenyon, MNN56827Montgomery Robert L · Port Angeles, WAN57061Cross Richard G · Brewster, MNN57621Mid Atlantic Air Museum · Reading, PAN57771Hilton Gregory L · Dallas, GAN57926Krog Donald C · Somerville, NJN58307Cavanaugh Flight Museum · Denison, TXN58528Riffle George W · Auburn, WAN58688Day Carl D · Sedan, KSN59585Wanagel Walter · Lisbon, CT
Back to Fairchild M-62A