Aerovodochody L-29 DELFIN
Registered aircraft · 67
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 ('0564310')
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 ('0564310')
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.
N105ECProp & Jet Air Museum · Romoland, CAN112AEPetty Michael C · Cedar Hill, TXN113AVPetty Clifford C · Cedar Hill, TXN119AWTarsky Project LLC · Panama City Beach, FLN126AWPhantom Phlyers LLC · Pearland, TXFirst renewal noticeN129BSRed Star Aero Holdings LLC · Mobile, ALN129MMHga LLC · Henderson, NVN129MRRace55sh LLC · Friendswood, TXN129TXVortex Control Systems Inc · Richardson, TXN154MMRiley Jacob · New York, NYN162SBHora Dwayne J · Mantorville, MNN179EPFf29 LLC · Park City, UTN199DMHga LLC · Henderson, NVN19HWPelland John J · Antioch, ILN20PLState Of Iowa University Of Iowa · Iowa City, IAN21KELindee Thomas W · Minnetonka, MNN222KJRoll John K · Newport News, VAN229DDFreeman Eugene P · Paducah, KYN229PTBlack Horse 29 LLC · Lewes, DEN237RLLeonardi Richard · Woodhaven, NYN268SPLas Vegas Spaceport Inc · Las Vegas, NVN27SRVintage Aero Collection Inc · Wilmington, DEN2819Badger Air Inc · Casa Grande, AZN2825QVipers Of Delaware Inc · Wilmington, DEN29ADAntique Aero Restorations LLC · Wilmington, DEN29JGSpeed And Angels LLC · Dover, DEN29KJMedore Doug · Romoland, CAN29MVLawrence Robert S · Martinez, CAN30CDRegistration Pending · Tehachapi, CARegistration pendingN3159YFantasy Fighters Inc · Santa Fe, NMN329CACzeskoslovenske Jets LLC · Lawrenceville, VAN333CAM & D Lee LLC · Arlington, WAN3624GGray Thomas M · Magnetic Springs, OHN37DGProp And Jet Air Museum Inc · Romoland, CAN3939LNiec Steven M · Clio, MIN4047JKeller Darin · Chehalis, WAN40973Pelland John J · Antioch, ILN41ADRiley Jacob · Tehachapi, CAN41PKRed Jet Foundation Inc · Long Lake, MNN429GCState Of Iowa · Iowa City, IAN43461Aviation Trust Co LLC Owner Trustee · Oklahoma City, OKN4477NLas Vegas Spaceport Inc · Las Vegas, NVN4985ZMathison John M · Fernley, NVN50DGLb Aero LLC · Santa Fe, NMN569LCEsterle Miroslav M · Franklin, WIN5959LSurfs Up Aero LLC · Wilmington, DEN61300Pro Aviation LLC · Colman, SDN6171MNikodem James E · Crystal Lake, ILN6216TKay Richard S · Riverside, CAN6235MColombo Brian · Oswego, NY
Back to Aerovodochody L-29 DELFIN