Martin Uav LLC
Earlier aircraft under this name · 50
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'MARTIN UAV LLC' OR list_contains(d.other_registrant_names, 'MARTIN UAV LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'MARTIN UAV LLC' OR list_contains(d.other_registrant_names, 'MARTIN UAV LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
Run 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.
N9298MMartin Uav V-BAT · S/N VBP-100021N975NDMartin Uav V-BAT · S/N VB-100090N911BKMartin Uav V-BAT · S/N VBP-100009N776MVMartin Uav V-BAT · S/N VBP-035N781MVMartin Uav V-BAT · S/N VBP-015N784MVMartin Uav V-BAT · S/N VBP-037N910ZJMartin Uav V-BAT · S/N VBP-067N9104GMartin Uav V-BAT · S/N VBP-100008N911FAMartin Uav V-BAT · S/N VBP-100010N929VEMartin Uav V-BAT · S/N VBP-100027N929WJMartin Uav V-BAT · S/N VBP-100023N949PKMartin Uav V-BAT · S/N VBP-100051N974NMMartin Uav V-BAT · S/N VB-100081N974SVMartin Uav V-BAT · S/N VB-100099N974TYMartin Uav V-BAT · S/N VB-100098N975LKMartin Uav V-BAT · S/N VB-100092N780MVMartin Uav V-BAT · S/N VBP-048N774MVMartin Uav V-BAT · S/N VBP-009N920NMMartin Uav V-BAT · S/N VBP-068N922FMMartin Uav V-BAT · S/N VBP-066N922GFMartin Uav V-BAT · S/N VBP-100011N930FMMartin Uav V-BAT · S/N VBP-100020N930UTMartin Uav V-BAT · S/N VBP-100019N931RMMartin Uav V-BAT · S/N VBP-100026N951LMMartin Uav V-BAT · S/N VB-100066N920LLMartin Uav V-BAT · S/N VBP-100014N934KBMartin Uav V-BAT · S/N VBP-054N928XVMartin Uav V-BAT · S/N VBP-041N9294SMartin Uav V-BAT · S/N VBP-33N929UMMartin Uav V-BAT · S/N VBP-100028N933ZMMartin Uav V-BAT · S/N VBP-100040N939UMartin Uav V-BAT · S/N VBP-100045N949KBMartin Uav V-BAT · S/N VBP-100047N949LGMartin Uav V-BAT · S/N VBP-100048N949NQMartin Uav V-BAT · S/N VBP-100050N949RMMartin Uav V-BAT · S/N VBP-100053N949SQMartin Uav V-BAT · S/N VBP-100054N9102VMartin Uav V-BAT · S/N VBP-100006N929YMMartin Uav V-BAT · S/N VBP-100036N930YDMartin Uav V-BAT · S/N VBP-100022N934AUMartin Uav V-BAT · S/N VBP-100035N934HMMartin Uav V-BAT · S/N VBP-100037N910VAMartin Uav V-BAT · S/N VBP-061N914BVMartin Uav V-BAT · S/N VBP-060N934GUMartin Uav V-BAT · S/N VBP-100039N32MVMartin Uav V-BAT · S/N VBP 001N48MVMartin Uav V-BAT · S/N VBP 002N13MVMartin Uav SUPER BAT DA-50 · S/N SBD 055N44MVMartin Uav SUPER BAT DA-50 · S/N SBD 056N53MVMartin Uav SUPER BAT DA-50 · S/N SBD 057
Back to Martin Uav LLC