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 ('05603SJ')
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 ('05603SJ')
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.
N10LWGirardi Mike R · Washington, DCN110FTEast Boulder LLC · Mc Leod, MTN11XNLdcs Holdings LLC · Boca Raton, FLN13031Blenis Gary DBA · Douglas, MAN136EMJdi Holdings LLC · Belgrade, MTN139DFCzech Six LLC · Lafayette, LAN139GXPitch N Power Aviation Inc · Jupiter, FLN139LWNo Fallen Hereos Foundation · Boca Raton, FLN139PJBlack Rock Aero LLC · Reno, NVN139RHRedstar Air Shows Inc · Discovery Bay, CAN139RSL39az LLC · Kalispell, MTN139TBBrig Air 5 LLC · Birmingham, MIN139TDPar Defense Aero LLC · Las Vegas, NVN139USNelson Jet Aviation LLC · Cave Creek, AZN139VSJs Air LLC · Mount Airy, NCN178CWCommerce Flight LLC · Commerce, TXN186RGNational Test Pilot School · Mojave, CAN20GXWide Open Skies Viii LLC · Belgrade, MTN223PGDt Aviation Consulting LLC · Atlanta, GAN239PWCirrus Design Corp · Duluth, MNN239RHRedstar Air Shows Inc · Discovery Bay, CAN23GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN25PXGauntlet Aerospace LLC · Henderson, NVN29HWFargo Air Museum · Fargo, NDN301MZMarine Aviation Museum Inc · Wilmington, DEN339LL39 Aircraft LLC · Alpine, WYN391ZANorthrop Grumman Systems Corp · El Segundo, CAFirst renewal noticeN399APTaylor Aero LLC · Lewes, DEN39AXEast Boulder LLC · Mc Leod, MTN39CVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN39CZFiler Daniel W · Alto, TXN39EXTeo Steel Inc · Ramer, TNN39GXPitch N Power Aviation Inc · Jupiter, FLN39LWFox3 International LLC · Scottsdale, AZN39SRRubino Sal · San Jose, CAN39UA39ua LLC · Kissimmee, FLN39VHGauntlet Aerospace LLC · Henderson, NVN39VMEdmund Noel · Houston, TXN39WFSierra Bravo Aviation LLC · Harrison, ARN49GGGainesville Aircraft Sales Inc · Gainesville, FLN49MHKalmar Istvan · Brookings, ORN539RFRedstar Air Shows Inc · Discovery Bay, CAN554RCForgotten Heroes Foundation · Chesapeake, VAN600DMWarbird Preservation Foundation · Bettendorf, IAN6380LRegistration Pending · Hickory, NCRegistration pendingN639RHTaylor Aero LLC · Lewes, DEN7231MRed Jet Foundation Inc · Long Lake, MNN729HBBravo Alpha Aerospace LLC · Camden, DEN77MHHoward Jesse · Houston, TXN805JHLawn Dart Aero LLC · Big Sky, MT
Back to Aero Vodochody L-39