Aero Vodochody L-39ZA
Registered aircraft · 25
Aircraft of this model in the FAA registry, by N-number.
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 ('05610PE')
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 ('05610PE')
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.
N107ZARavn Group Inc · Las Vegas, NVN109ZARavn Group Inc · Las Vegas, NVN135EMJdi Holdings LLC · Belgrade, MTN139ZAWooding William W · Anacortes, WAN214AXAirborne Tactical Advantage Co LLC · Newport News, VAN215AXAirborne Tactical Advantage Co LLC · Newport News, VAN216AXAirborne Tactical Advantage Co LLC · Newport News, VAN217AXAirborne Tactical Advantage Co LLC · Newport News, VAN339ZAState University Of Iowa · Iowa City, IAN343WTPhantom Phlyers LLC · Pearland, TXN390ZACoastal Defense Inc · Mill Hall, PAN394ZAKitov Resources Corp · Shorewood, WIN395ZAFlight Czech LLC · Maquon, ILN397ZAEagle Air LLC · Boulder, CON399ZACoastal Defense Inc · Mill Hall, PAN39LKFsa Aerospace Inc Trustee · Wilmington, DEN39LSFsa Aerospace Inc Trustee · Wilmington, DEN39LVFsa Aerospace Inc Trustee · Wilmington, DEN39ZAVeruca Salt LLC · Washington, TXN401ZACzech Six LLC · Lafayette, LAN402ZAPristine Warbird Holdings And Promotions Inc · Calabasas, CAN403ZAPristine Warbird Holdings And Promotions Inc · Calabasas, CAN405ZARavn Group Inc · Las Vegas, NVN7511QT 28 Inc · Dover, DEN909ZACoastal Defense Inc · Mill Hall, PA
Back to Aero Vodochody L-39ZA